ORA-14099: all rows in table do not qualify for specified
partition



ORA-14099: all rows in table do not qualify for specified partition..

Answer / guest

Cause: There is at least one row in the non partitioned
table which does not qualify for the partition specified in
the ALTER TABLE EXCHANGE PARTITION

Action: Ensure that all the rows in the segment qualify for
the partition. Perform the alter table operation with the NO
CHECKING option. Run ANALYZE table VALIDATE on that
partition to find out the invalid rows and delete them.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07470: snclget: cannot get cluster number.

1 Answers  


ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

1 Answers  


ORA-32815: message system link string is referenced by a foreign queue

1 Answers  


TNS-12665: NLS string open failed

1 Answers  


RMAN-08580: channel string: starting datafile copy

1 Answers  






ORA-30182: invalid precision specifier

1 Answers  


RMAN-08106: channel string: restoring block(s)

1 Answers  


ORA-02236: invalid file name

1 Answers  


ORA-02380: profile string does not exist

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  


PCC-02418: Array size mismatch between Object and REF host variables

1 Answers  


ORA-31615: routine string received this error: string

1 Answers  


Categories