Create a table based on a hash cluster : Create Table « Table « Oracle PL/SQL Tutorial

SQL>
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>
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.

6.1.Create Table
	6.1.1.	Creating a Table
	6.1.2.	Create table with storage setting
	6.1.3.	Create table with storage setting 2
	6.1.4.	Create an external table
	6.1.5.	Create copy table
	6.1.6.	Create a table from one or more other tables
	6.1.7.	Rename a table
	6.1.8.	One column with three constraints
	6.1.9.	Use referencing columns
	6.1.10.	Create a table based on a hash cluster
	6.1.11.	Create table with 'organization index OVERFLOW'
	6.1.12.	Create table with 'organization index'
	6.1.13.	Cascade delete setting
	6.1.14.	Demonstrate a simple External table
	6.1.15.	Create intermediate table for calculation
	6.1.16.	Make myCode a CACHE table.