ORA-14286: cannot COALESCE the only subpartition of this
table partition



ORA-14286: cannot COALESCE the only subpartition of this table partition..

Answer / guest

Cause: A COALESCE SUBPARTITION command was issued when there
is only one subpartition in the partition which is illegal

Action: Ensure that there is at least one subpartition. Drop
partition to remove all subpartitions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00308: this construct is not allowed as the origin of an assignment

1 Answers  


ORA-31102: Already locked in exclusive mode. Cannot add lock.

1 Answers  


TNS-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA

1 Answers  


PROT-00301: Dump is not feasible when clusterware is running

1 Answers  


NZE-28838: no identity descriptor

1 Answers  






ORA-25175: no PRIMARY KEY constraint found

1 Answers  


DRG-13311: USER_LEXER stored procedure name contains a semicolon

1 Answers  


TNS-03603: Encountered a node with a version eariler than SQL*Net 2.3

1 Answers  


RMAN-04005: error from target database: string

1 Answers  


TNS-04140: Migration completed successfully.

1 Answers  


ORA-00342: archived log does not have expected resetlogs SCN string

1 Answers  


RMAN-06183: datafile or datafilecopy larger than MAXSETSIZE: file# string string

1 Answers  


Categories