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

QSM-02030: reduced precision specified for prebuilt mv

1 Answers  


PLS-00669: Type of expression should be a valid collection variable

1 Answers  


ORA-27154: post/wait create failed

1 Answers  


ORA-30435: job_queue_processes must be non-zero in order to refresh summaries

1 Answers  


ORA-09798: Label comparison failed.

2 Answers  






ORA-19685: SPFILE could not be verified

1 Answers  


NNO-00854: error unbinding LDAP: error = number

1 Answers  


ORA-24333: zero iteration count

2 Answers   IBM,


ORA-28168: attempted to grant password-protected role

1 Answers  


AMD-00115: PROCEDURE string, invalid file handle

1 Answers  


NNL-00267: Address is string

1 Answers  


NZE-28857: Unknown SSL error

1 Answers  


Categories