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-30341: dropped level has references

1 Answers  


PLS-01906: : raw variable length too long

1 Answers  


RMAN-06468: Invalid Data Block Address: number

1 Answers  


ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  


ORA-12725: unmatched parentheses in regular expression

1 Answers  






ORA-27078: unable to determine limit for open files

1 Answers  


ORA-19320: Host name not specified in HTTP URL

1 Answers  


NNO-00616: enabling DEFAULT-FORWARDERS-ONLY mode

1 Answers  


ORA-01859: a non-alphabetic character was found where an alphabetic was expected

1 Answers  


ORA-00102: network protocol string cannot be used by dispatchers

1 Answers  


SQL*Loader-00123: specified value for bindsize(number) less than readsize(number)

1 Answers  


NID-00315: Operation already in progress, continuing

1 Answers  


Categories