ORA-14280: all rows in table do not qualify for specified
subpartition
- 1 Answers
- 3948 Views
- I also Faced
- E-Mail Answers
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-14513: partitioning column may not be of object datatype
PLS-01421: FOR UPDATE clause
KUP-04066: error initializing access to external table source
NZE-29108: Cannot initialize random object.
ORA-19725: can not acquire plug-in enqueue
ORA-13267: error reading data from layer table string
SQL*Loader-00653: XML data set to NULL in column string, row number, table string
NNO-00065: loading cached data from checkpoint file "string"
ORA-16538: no match on requested item
IMG-00002: unrecoverable error
ORA-09805: conversion of category number to string failed.
ORA-23403: refresh group "string"."string" already exists
Oracle Errors 
