Exclusive aggregation using the clustering technique : Cluster « Table « Oracle PL / SQL






Exclusive aggregation using the clustering technique

   
SQL>
SQL>
SQL> CREATE TABLE Hard_Disk
  2     (hd_id            VARCHAR2(10) NOT NULL,
  3      capacity         VARCHAR2(20),
  4      PRIMARY KEY (hd_id))
  5     CLUSTER Part_Cluster(hd_id);

Table created.

SQL>
SQL> CREATE TABLE PartType
  2     (hd_id            VARCHAR2(10) NOT NULL,
  3      PartType_id      VARCHAR2(10) NOT NULL,
  4      description      VARCHAR2(25),
  5      PRIMARY KEY (PartType_id),
  6      FOREIGN KEY (hd_id) REFERENCES Hard_Disk (hd_id))
  7     CLUSTER Part_Cluster(hd_id);

Table created.

SQL>
SQL> drop table Hard_Disk  cascade constraints;

Table dropped.

SQL> drop table PartType cascade constraints;

Table dropped.

SQL>

   
    
    
  








Related examples in the same category

1.create cluster
2.Cluster with varchar2 column
3.Create cluster and set hashkeys, size
4.Create cluster and then create table on top of it
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