ORA-14285: cannot COALESCE the only partition of this hash
partitioned table or index



ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index..

Answer / guest

Cause: A COALESCE PARTITION command was issued when there is
only one partition in the table or index, which is illegal

Action: Ensure that there is at least one partition. Drop
the table or index to remove all partitions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06909: CMX: error during acknowledge of ORACLE_SID

1 Answers  


ORA-02439: Unique index on a deferrable constraint is not allowed

1 Answers  


ORA-31432: invalid source table

1 Answers  


ORA-16769: The physical standby database is incorrectly put into read-only state.

1 Answers  


ORA-06113: NETTCP: Too many connections

1 Answers  






TNS-01066: Presentation: string

1 Answers  


ORA-16795: Database resource guard detects that database reinstantiation is required

1 Answers  


ORA-19554: error allocating device, device type: string, device name: string

1 Answers  


ORA-14006: invalid partition name

1 Answers  


ORA-12571: TNS:packet writer failure

1 Answers  


ORA-02839: Sync of blocks to disk failed.

1 Answers  


ORA-08182: operation not supported while in Flashback mode

1 Answers  


Categories