Wednesday, January 16, 2008

ORA-00951: cluster not empty

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

A cluster can be dropped only if the participating tables have been dropped first, otherwise you'll get:
ORA-00951: cluster not empty
Alternatively, if you are absolutely sure, you can add the INCLUDING TABLES clause:
drop CLUSTER dummy_cluster INCLUDING TABLES
/
If there are any tables whose constraints point to the cluster table and are preventing you from dropping the cluster and the tables, you can also add the CASCADE CONSTRAINTS clause to the statement:
drop CLUSTER dummy_cluster INCLUDING TABLES CASCADE CONSTRAINTS
/

See message translations for ORA-00951 and search additional resources
at

No comments:

Post a Comment

I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio