Create cluster and then create table on top of it : Cluster « Table « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Table
3. Cluster

SQL> create table myTable(
  2    key_col  primary key,
  3    key_val
  4  )as
  5  select object_name, max( owner||'_'||object_id )from all_objects group by object_name
  6  /

Table created.

SQL>
SQL>
SQL> create cluster myTableHash(
  2      key_col varchar2(30)
  3  )
  4  single table
  5  hashkeys 20000
  6  size 255
  7  /

Cluster created.

SQL>
SQL>
SQL> create table lookup_hash(
  2     key_col,
  3     key_val )
  4  cluster myTableHash(key_col)
  5  as
  6  select * from myTable;

Table created.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL> drop table lookup_hash;

Table dropped.

SQL> drop cluster myTableHash;

Cluster dropped.