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






Create cluster and then create table on top of it

   
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.

   
    
    
  








Related examples in the same category

1.create cluster
2.Cluster with varchar2 column
3.Create cluster and set hashkeys, size
4.Exclusive aggregation using the clustering technique
5.Existence-dependent aggregation using the clustering technique
6.Oracle provides a clustering technique that can be very useful for an aggregation relationship.
7.drop cluster