클러스터 사용

클러스터 사용

SVRMGR> create tablespace clustered_data_02
     2> datafile '/usr/local/Oracle/oradata/test/cluster.dbf' size 10m;
명령문이 처리되었습니다

SVRMGR> create cluster cluster_test
	2> (invoice_id varchar2(20))
	3> pctused 90 pctfree 5 size 400
	4> tablespace clustered_data_02
	5> storage(initial 1m next 1m minextents 2 maxextents 100 pctincrease 50);
명령문이 처리되었습니다

SVRMGR> create table invoice(
     2> invoice_id varchar2(20) primary key,
	3> user_account varchar2(9),
	4> pmt_dttm date)
	5> 
명령문이 처리되었습니다
SVRMGR> create table invoice_item(
	2> invoice_id varchar2(20) primary key,
	3> part_id varchar2(10),
	4> item_amount number)
	5> 
명령문이 처리되었습니다
SVRMGR> create table invoice_detail(
	2> invoice_id varchar2(20) primary key,
	3> prchs_address varchar2(20),
	4> purchaser_zip varchar2(10))
	5> 
명령문이 처리되었습니다

SVRMGR> create index cluster_test_index
     2> on cluster cluster_test
	3> tablespace clustered_data_02
	4> storage(initial 1m next 1m minextents 2 maxextents 50 pctincrease 50) pctfree 5;
명령문이 처리되었습니다

Copyleft(C) 명규의 오라클OCP All rights free