스키마브라우저에서 composite partition으로 생성한 테이블의 정보와 인덱스정보가 Script로 다르게 생성이 됩니다. 사용데이터 베이스 정보 Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production -- 실제 생성 테이블 CREATE TABLE F00_Sales ( userid NUMBER(10) NOT NULL, sale_day_key NUMBER(5) NOT NULL, biz_key NUMBER(2) NOT NULL, sell_price NUMBER(13,4) NOT NULL ) PCTFREE 0 TABLESPACE DM_FD_M PARTITION BY RANGE (sale_day_key) SUBPARTITION BY LIST (biz_key) SUBPARTITION TEMPLATE (SUBPARTITION shop VALUES(1) TABLESPACE DM_FD_M ,SUBPARTITION lott VALUES(2) TABLESPACE DM_FD_L ,SUBPARTITION cafy VALUES(3) TABLESPACE DM_FD_S ) (PARTITION p305 VALUES LESS THAN (152) (SUBPARTITION PSH305 VALUES(1) TABLESPACE DM_FD_F00_PSH0305 -- UniForm Size : 5M ,SUBPARTITION PLT305 VALUES(2) TABLESPACE DM_FD_F00_PLT0305 -- UniForm Size : 10M, initial 70M ,SUBPARTITION PCF305 VALUES(3) TABLESPACE DM_FD_F00_PCF0305 -- UniForm Size : 1M ) ,PARTITION p306 VALUES LESS THAN (182) (SUBPARTITION PSH306 VALUES(1) TABLESPACE DM_FD_F00_PSH0306 ,SUBPARTITION PLT306 VALUES(2) TABLESPACE DM_FD_F00_PLT0306 ,SUBPARTITION PCF306 VALUES(3) TABLESPACE DM_FD_F00_PCF0306 ) ); -- 오렌지 생성 스크립트 CREATE TABLE "DM"."F00_SALES" ( "USERID" NUMBER(10), "SALE_DAY_KEY" NUMBER(5), "BIZ_KEY" NUMBER(2), "SELL_PRICE" NUMBER(13,4) ) PARTITION BY RANGE("SALE_DAY_KEY") SUBPARTITION BY HASH("BIZ_KEY") ( PARTITION P305 VALUES LESS THAN (152) PCTFREE 0 ( SUBPARTITION PSH305 TABLESPACE DM_FD_F00_PSH305 STORAGE ( INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ), SUBPARTITION PLT305 TABLESPACE DM_FD_F00_PLT305 STORAGE ( INITIAL 10485760 NEXT 10485760 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ), SUBPARTITION PCF305 TABLESPACE DM_FD_F00_PCF305 STORAGE ( INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ), PARTITION P306 VALUES LESS THAN (182) PCTFREE 0 ( SUBPARTITION PSH306 TABLESPACE DM_FD_F00_PSH306 STORAGE ( INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ), SUBPARTITION PLT306 TABLESPACE DM_FD_F00_PLT306 STORAGE ( INITIAL 10485760 NEXT 10485760 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ), SUBPARTITION PCF306 TABLESPACE DM_FD_F00_PCF306 STORAGE ( INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ) ); -- 실제 생성 인덱스 스크립트 CREATE BITMAP INDEX F00_biz_key_bmp ON F00_Sales(biz_key) TABLESPACE DM_FI_S LOCAL (PARTITION P0305 (SUBPARTITION PSH0305 TABLESPACE DM_FI_F00_PSH0305 ,SUBPARTITION PLT0305 TABLESPACE DM_FI_F00_PLT0305 ,SUBPARTITION PCF0305 TABLESPACE DM_FI_F00_PCF0305 ) ,PARTITION P0306 (SUBPARTITION PSH0306 TABLESPACE DM_FI_F00_PSH0306 ,SUBPARTITION PLT0306 TABLESPACE DM_FI_F00_PLT0306 ,SUBPARTITION PCF0306 TABLESPACE DM_FI_F00_PCF0306 ) ); -- 오렌지 생성 스크립트 CREATE BITMAP INDEX "DM"."F00_BIZ_KEY_BMP" ON "DM"."F00_SALES"("BIZ_KEY") LOCAL ( PARTITION P305, PARTITION P306 );