SQL>
SQL> create cluster hash_cluster
2 ( hash_key number )
3 hashkeys 1000
4 size 8192
5 /
Cluster created.
SQL>
SQL> create table hashed_table
2 (x number, data1 varchar2(4000), data2 varchar2(4000) )
3 cluster hash_cluster(x);
Table created.
SQL>
SQL> drop cluster hash_cluster;
drop cluster hash_cluster
*
ERROR at line 1:
ORA-00951: cluster not empty
SQL>
SQL> drop table hashed_table;
Table dropped.