ORA-14280: all rows in table do not qualify for specified
subpartition



ORA-14280: all rows in table do not qualify for specified subpartition..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-37078: (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.

1 Answers  


DRG-10826: no document with the specified textkey is found

1 Answers  


ORA-29310: database is not open, or opened as a clone

1 Answers  


DRG-10513: index string metadata is corrupt

1 Answers  


ORA-02493: invalid file increment size in NEXT clause

1 Answers  






VID-00705: unsupported input format

1 Answers  


PCC-02441: Number of attributes does not match number of host variables

1 Answers  


ORA-29532: Java call terminated by uncaught Java exception: string

1 Answers  


ORA-02184: resource quotas are not allowed in REVOKE

1 Answers  


QSM-01054: no join match between query and summary, string

1 Answers  


ORA-01259: unable to delete datafile string

1 Answers  


ORA-24009: invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE

1 Answers  


Categories