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 |
ORA-14155: missing PARTITION or SUBPARTITION keyword
ORA-30772: opaque types do not have default constructors
ORA-15064: communication failure with ASM instance
PCC-00108: This statement is not supported by ANSI
ORA-01616: instance string (thread string) is open - cannot disable
PLS-00659: constructor method must return SELF AS RESULT
ORA-31014: Attempted to delete the root container
IMP-00039: VOLSIZE does not match the value used for export: string
ORA-14644: table is not subpartitioned by Hash method
TNS-12623: TNS:operation is illegal in this state
ORA-30018: Create Rollback Segment failed, USN string is out of range
ORA-19908: datafile string has invalid checkpoint