復制代碼 代碼如下:

create cluster my_clu (deptno number )
pctused 60
pctfree 10
size 1024
tablespace users
storage (
initial 128 k
next 128 k
minextents 2
maxextents 20
);

復制代碼 代碼如下:

create table t1_dept(
deptno number ,
dname varchar2 ( 20 )
)
cluster my_clu(deptno);
create table t1_emp(
empno number ,
ename varchar2 ( 20 ),
birth_date date ,
deptno number
)
cluster my_clu(deptno);

復制代碼 代碼如下:

create index clu_index on cluster my_clu;

復制代碼 代碼如下:

alter cluster my_clu
pctused 40

復制代碼 代碼如下:

drop cluster my_clu; -- 僅適用于刪除空簇
drop cluster my_clu including tables ; -- 刪除簇和簇表
drop cluster my_clu including tables cascade constraints ;--同時刪除外鍵約束

復制代碼 代碼如下:

truncate cluster my_clu;

復制代碼 代碼如下:

create cluster my_clu_two(empno number(10) )
pctused 70
pctfree 10
tablespace users
hash is empno
hashkeys 150 ;

復制代碼 代碼如下:

create table t2_emp (
empno number ( 10 ),
ename varchar2 ( 20 ),
birth_date date ,
deptno number )
cluster my_clu_two(empno);