ORA-14099: all rows in table do not qualify for specified
partition
- 1 Answers
- 4672 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 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 |
NNL-00514: Creates a new name with a default TTL
LCD-00203: missing keyword [string]
SQL*Loader-00429: insufficient number of elements found for varray
ORA-09980: skxfqdrcv: Error Receiving a message from another endpoint
ORA-21521: exceeded maximum number of connections in OCI (object mode only)
ORA-01590: number of segment free list (string) exceeds maximum of string
RMAN-08001: restore not complete
IMP-00071: Object identifier of imported table mismatches object identifier of existing table
ORA-01543: tablespace 'string' already exists
ORA-01752: cannot delete from view without exactly one key-preserved table
ORA-25294: Queue string has a buffer
PCC-02012: did not find matching quote for char constant
Oracle Errors 
