Oracle Solution for Error ora-14285
ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index
What triggered the Error:
A COALESCE PARTITION command was issued when there is only one partition in the table or index, which is illegalWhat should we do to fix it:
Ensure that there is at least one partition. Drop the table or index to remove all partitions.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
