Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\createTableIndexVer.sql
rem Generated for Warehouse Builder by cwmgen create table CMPFCOStorage ( WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null, SnapshotID NUMBER(9) default 0, CompUOID VARCHAR2(255), isSeed NUMBER(1) default 1, active NUMBER(1) default 0, DeletionParent NUMBER(9), LoadingParent NUMBER(9), b_1 CHAR(1), b_2 CHAR(1), b_3 CHAR(1), b_4 CHAR(1), b_5 CHAR(1), b_6 CHAR(1), b_7 CHAR(1), b_8 CHAR(1), b_9 CHAR(1), b_10 CHAR(1), b_11 CHAR(1), b_12 CHAR(1), b_13 CHAR(1), b_14 CHAR(1), b_15 CHAR(1), b_16 CHAR(1), b_17 CHAR(1), b_18 CHAR(1), i_1 NUMBER(9), i_2 NUMBER(9), i_3 NUMBER(9), i_4 NUMBER(9), i_5 NUMBER(9), i_6 NUMBER(9), i_7 NUMBER(9), i_8 NUMBER(9), i_9 NUMBER(9), i_10 NUMBER(9), i_11 NUMBER(9), d_1 DATE, d_2 DATE, t_1 TIMESTAMP, t_2 TIMESTAMP, t_3 TIMESTAMP, t_4 TIMESTAMP, t_5 TIMESTAMP, t_6 TIMESTAMP, t_7 TIMESTAMP, t_8 TIMESTAMP, t_9 TIMESTAMP, t_10 TIMESTAMP, t_11 TIMESTAMP, t_12 TIMESTAMP, t_13 TIMESTAMP, t_14 TIMESTAMP, t_15 TIMESTAMP, f_1 FLOAT, f_2 FLOAT, s1_1 VARCHAR2(40), s1_2 VARCHAR2(40), s1_3 VARCHAR2(40), s1_4 VARCHAR2(40), s1_5 VARCHAR2(40), s1_6 VARCHAR2(40), s1_7 VARCHAR2(40), s1_8 VARCHAR2(40), s1_9 VARCHAR2(40), s1_10 VARCHAR2(40), s1_11 VARCHAR2(40), s1_12 VARCHAR2(40), s1_13 VARCHAR2(40), s1_14 VARCHAR2(40), s1_15 VARCHAR2(40), s2_1 VARCHAR2(255), s2_2 VARCHAR2(255), s2_3 VARCHAR2(255), s2_4 VARCHAR2(255), s2_5 VARCHAR2(255), s2_6 VARCHAR2(255), s2_7 VARCHAR2(255), s2_8 VARCHAR2(255), s2_9 VARCHAR2(255), s2_10 VARCHAR2(255), s2_11 VARCHAR2(255), s2_12 VARCHAR2(255), s2_13 VARCHAR2(255), s2_14 VARCHAR2(255), s2_15 VARCHAR2(255), s2_16 VARCHAR2(255), s2_17 VARCHAR2(255), s4_1 VARCHAR2(1000), s4_2 VARCHAR2(1000), s3_1 VARCHAR2(4000), s3_2 VARCHAR2(4000), s3_3 VARCHAR2(4000), s3_4 VARCHAR2(4000), s3_5 VARCHAR2(4000), s3_6 VARCHAR2(4000), s3_7 VARCHAR2(4000), s3_8 VARCHAR2(4000), s3_9 VARCHAR2(4000), cl_1 CLOB, cl_2 CLOB, cl_3 CLOB, cl_4 CLOB, cl_5 CLOB, bl_1 BLOB, r_1 NUMBER(9), r_2 NUMBER(9), r_3 NUMBER(9), r_4 NUMBER(9), r_5 NUMBER(9), r_6 NUMBER(9), r_7 NUMBER(9), r_8 NUMBER(9), r_9 NUMBER(9), r_10 NUMBER(9), r_11 NUMBER(9), r_12 NUMBER(9), r_13 NUMBER(9), r_14 NUMBER(9), r_15 NUMBER(9), r_16 NUMBER(9), r_17 NUMBER(9), r_18 NUMBER(9), r_19 NUMBER(9) ) TABLESPACE %snapshot_store_ts; alter table CMPFCOStorage modify r_6 default 0; create unique index IDX_FCOELEMENTID_VER on CMPFCOStorage ( WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex; alter table CMPFCOStorage nologging add constraint IDX_FCOELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID); create index IDX_FCOSNAPID_Ver on CMPFCOStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex; create index IDX_FCOCompUOID_Ver on CMPFCOStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex; create index IDX_FCOUOID_Ver on CMPFCOStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex; create index IDX_FCOActiveClassName_Ver on CMPFCOStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex; create index IDX_FCOLoadingParent_Ver on CMPFCOStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex; create index IDX_FCOOwningFolder_Ver on CMPFCOStorage (WorkspaceID, r_6) nologging compress tablespace %tndex; create index IDX_FCOFCOClass_Ver on CMPFCOStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex; create table CMPMMMStorage ( WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null, SnapshotID NUMBER(9) default 0, CompUOID VARCHAR2(255), isSeed NUMBER(1) default 1, active NUMBER(1) default 0, DeletionParent NUMBER(9), LoadingParent NUMBER(9), b_1 CHAR(1), b_2 CHAR(1), b_3 CHAR(1), b_4 CHAR(1), b_5 CHAR(1), b_6 CHAR(1), b_7 CHAR(1), b_8 CHAR(1), b_9 CHAR(1), b_10 CHAR(1), b_11 CHAR(1), b_12 CHAR(1), b_13 CHAR(1), b_14 CHAR(1), b_15 CHAR(1), b_16 CHAR(1), b_17 CHAR(1), b_18 CHAR(1), b_19 CHAR(1), b_20 CHAR(1), i_1 NUMBER(9), i_2 NUMBER(9), i_3 NUMBER(9), i_4 NUMBER(9), i_5 NUMBER(9), d_1 DATE, d_2 DATE, t_1 TIMESTAMP, t_2 TIMESTAMP, s1_1 VARCHAR2(40), s1_2 VARCHAR2(40), s1_3 VARCHAR2(40), s2_1 VARCHAR2(255), s2_2 VARCHAR2(255), s2_3 VARCHAR2(255), s2_4 VARCHAR2(255), s2_5 VARCHAR2(255), s2_6 VARCHAR2(255), s2_7 VARCHAR2(255), s2_8 VARCHAR2(255), s2_9 VARCHAR2(255), s4_1 VARCHAR2(1000), s3_1 VARCHAR2(4000), s3_2 VARCHAR2(4000), s3_3 VARCHAR2(4000), s3_4 VARCHAR2(4000), r_1 NUMBER(9), r_2 NUMBER(9), r_3 NUMBER(9), r_4 NUMBER(9), r_5 NUMBER(9), r_6 NUMBER(9) ) TABLESPACE %snapshot_store_ts; create table CMPSCOStorage ( WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null, SnapshotID NUMBER(9) default 0, CompUOID VARCHAR2(255), isSeed NUMBER(1) default 1, active NUMBER(1) default 0, DeletionParent NUMBER(9), LoadingParent NUMBER(9), b_1 CHAR(1), b_2 CHAR(1), b_3 CHAR(1), b_4 CHAR(1), b_5 CHAR(1), b_6 CHAR(1), b_7 CHAR(1), b_8 CHAR(1), b_9 CHAR(1), b_10 CHAR(1), b_11 CHAR(1), b_12 CHAR(1), b_13 CHAR(1), b_14 CHAR(1), b_15 CHAR(1), b_16 CHAR(1), b_17 CHAR(1), b_18 CHAR(1), b_19 CHAR(1), b_20 CHAR(1), b_21 CHAR(1), b_22 CHAR(1), i_1 NUMBER(9), i_2 NUMBER(9), i_3 NUMBER(9), i_4 NUMBER(9), i_5 NUMBER(9), i_6 NUMBER(9), i_7 NUMBER(9), i_8 NUMBER(9), i_9 NUMBER(9), i_10 NUMBER(9), i_11 NUMBER(9), i_12 NUMBER(9), i_13 NUMBER(9), i_14 NUMBER(9), i_15 NUMBER(9), i_16 NUMBER(9), i_17 NUMBER(9), i_18 NUMBER(9), i_19 NUMBER(9), i_20 NUMBER(9), d_1 DATE, d_2 DATE, d_3 DATE, t_1 TIMESTAMP, t_2 TIMESTAMP, t_3 TIMESTAMP, t_4 TIMESTAMP, t_5 TIMESTAMP, t_6 TIMESTAMP, t_7 TIMESTAMP, t_8 TIMESTAMP, t_9 TIMESTAMP, t_10 TIMESTAMP, t_11 TIMESTAMP, t_12 TIMESTAMP, t_13 TIMESTAMP, s1_1 VARCHAR2(40), s1_2 VARCHAR2(40), s1_3 VARCHAR2(40), s1_4 VARCHAR2(40), s1_5 VARCHAR2(40), s1_6 VARCHAR2(40), s1_7 VARCHAR2(40), s1_8 VARCHAR2(40), s1_9 VARCHAR2(40), s1_10 VARCHAR2(40), s1_11 VARCHAR2(40), s2_1 VARCHAR2(255), s2_2 VARCHAR2(255), s2_3 VARCHAR2(255), s2_4 VARCHAR2(255), s2_5 VARCHAR2(255), s2_6 VARCHAR2(255), s2_7 VARCHAR2(255), s2_8 VARCHAR2(255), s2_9 VARCHAR2(255), s2_10 VARCHAR2(255), s2_11 VARCHAR2(255), s2_12 VARCHAR2(255), s2_13 VARCHAR2(255), s2_14 VARCHAR2(255), s2_15 VARCHAR2(255), s4_1 VARCHAR2(1000), s4_2 VARCHAR2(1000), s3_1 VARCHAR2(4000), s3_2 VARCHAR2(4000), s3_3 VARCHAR2(4000), s3_4 VARCHAR2(4000), s3_5 VARCHAR2(4000), s3_6 VARCHAR2(4000), s3_7 VARCHAR2(4000), s3_8 VARCHAR2(4000), cl_1 CLOB, cl_2 CLOB, cl_3 CLOB, r_1 NUMBER(9), r_2 NUMBER(9), r_3 NUMBER(9), r_4 NUMBER(9), r_5 NUMBER(9), r_6 NUMBER(9), r_7 NUMBER(9), r_8 NUMBER(9), r_9 NUMBER(9), r_10 NUMBER(9), r_11 NUMBER(9), r_12 NUMBER(9), r_13 NUMBER(9), r_14 NUMBER(9), r_15 NUMBER(9), r_16 NUMBER(9), r_17 NUMBER(9), r_18 NUMBER(9) ) TABLESPACE %snapshot_store_ts; create unique index IDX_SCOELEMENTID_VER on CMPSCOStorage ( WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex; alter table CMPSCOStorage nologging add constraint IDX_SCOELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID); create index IDX_SCOSNAPID_Ver on CMPSCOStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex; create index IDX_SCOCompUOID_Ver on CMPSCOStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex; create index IDX_SCOUOID_Ver on CMPSCOStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex; create index IDX_SCOActiveClassName_Ver on CMPSCOStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex; create index IDX_SCOLoadingParent_Ver on CMPSCOStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex; create index IDX_SCOOwningFolder_Ver on CMPSCOStorage (WorkspaceID, r_6) nologging compress tablespace %tndex; create index IDX_SCOFCOClass_Ver on CMPSCOStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex; create table CMPSCOCfgStorage ( WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null, SnapshotID NUMBER(9) default 0, CompUOID VARCHAR2(255), isSeed NUMBER(1) default 1, active NUMBER(1) default 0, DeletionParent NUMBER(9), LoadingParent NUMBER(9), b_1 CHAR(1), b_2 CHAR(1), b_3 CHAR(1), b_4 CHAR(1), b_5 CHAR(1), b_6 CHAR(1), b_7 CHAR(1), b_8 CHAR(1), b_9 CHAR(1), b_10 CHAR(1), b_11 CHAR(1), b_12 CHAR(1), b_13 CHAR(1), b_14 CHAR(1), b_15 CHAR(1), b_16 CHAR(1), b_17 CHAR(1), b_18 CHAR(1), b_19 CHAR(1), i_1 NUMBER(9), i_2 NUMBER(9), i_3 NUMBER(9), i_4 NUMBER(9), i_5 NUMBER(9), i_6 NUMBER(9), i_7 NUMBER(9), i_8 NUMBER(9), i_9 NUMBER(9), i_10 NUMBER(9), i_11 NUMBER(9), i_12 NUMBER(9), i_13 NUMBER(9), i_14 NUMBER(9), i_15 NUMBER(9), i_16 NUMBER(9), i_17 NUMBER(9), i_18 NUMBER(9), i_19 NUMBER(9), i_20 NUMBER(9), i_21 NUMBER(9), i_22 NUMBER(9), i_23 NUMBER(9), d_1 DATE, d_2 DATE, d_3 DATE, d_4 DATE, t_1 TIMESTAMP, t_2 TIMESTAMP, t_3 TIMESTAMP, t_4 TIMESTAMP, t_5 TIMESTAMP, t_6 TIMESTAMP, t_7 TIMESTAMP, t_8 TIMESTAMP, t_9 TIMESTAMP, t_10 TIMESTAMP, t_11 TIMESTAMP, t_12 TIMESTAMP, t_13 TIMESTAMP, t_14 TIMESTAMP, t_15 TIMESTAMP, t_16 TIMESTAMP, t_17 TIMESTAMP, t_18 TIMESTAMP, t_19 TIMESTAMP, t_20 TIMESTAMP, t_21 TIMESTAMP, t_22 TIMESTAMP, t_23 TIMESTAMP, f_1 FLOAT, f_2 FLOAT, s1_1 VARCHAR2(40), s1_2 VARCHAR2(40), s1_3 VARCHAR2(40), s1_4 VARCHAR2(40), s1_5 VARCHAR2(40), s1_6 VARCHAR2(40), s1_7 VARCHAR2(40), s1_8 VARCHAR2(40), s1_9 VARCHAR2(40), s1_10 VARCHAR2(40), s1_11 VARCHAR2(40), s1_12 VARCHAR2(40), s1_13 VARCHAR2(40), s1_14 VARCHAR2(40), s1_15 VARCHAR2(40), s1_16 VARCHAR2(40), s2_1 VARCHAR2(255), s2_2 VARCHAR2(255), s2_3 VARCHAR2(255), s2_4 VARCHAR2(255), s2_5 VARCHAR2(255), s2_6 VARCHAR2(255), s2_7 VARCHAR2(255), s2_8 VARCHAR2(255), s2_9 VARCHAR2(255), s4_1 VARCHAR2(1000), s4_2 VARCHAR2(1000), s3_1 VARCHAR2(4000), s3_2 VARCHAR2(4000), s3_3 VARCHAR2(4000), s3_4 VARCHAR2(4000), s3_5 VARCHAR2(4000), s3_6 VARCHAR2(4000), s3_7 VARCHAR2(4000), s3_8 VARCHAR2(4000), s3_9 VARCHAR2(4000), s3_10 VARCHAR2(4000), s3_11 VARCHAR2(4000), s3_12 VARCHAR2(4000), s3_13 VARCHAR2(4000), cl_1 CLOB, cl_2 CLOB, cl_3 CLOB, r_1 NUMBER(9), r_2 NUMBER(9), r_3 NUMBER(9), r_4 NUMBER(9), r_5 NUMBER(9), r_6 NUMBER(9), r_7 NUMBER(9), r_8 NUMBER(9), r_9 NUMBER(9), r_10 NUMBER(9), r_11 NUMBER(9), r_12 NUMBER(9), r_13 NUMBER(9), r_14 NUMBER(9), r_15 NUMBER(9), r_16 NUMBER(9), r_17 NUMBER(9), r_18 NUMBER(9), r_19 NUMBER(9), r_20 NUMBER(9), r_21 NUMBER(9), r_22 NUMBER(9), r_23 NUMBER(9) ) TABLESPACE %snapshot_store_ts; create unique index IDX_SCOCfgELEMENTID_VER on CMPSCOCfgStorage ( WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex; alter table CMPSCOCfgStorage nologging add constraint IDX_SCOCfgELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID); create index IDX_SCOCfgSNAPID_Ver on CMPSCOCfgStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex; create index IDX_SCOCfgCompUOID_Ver on CMPSCOCfgStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex; create index IDX_SCOCfgUOID_Ver on CMPSCOCfgStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex; create index IDX_SCOCfgActiveClassName_Ver on CMPSCOCfgStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex; create index IDX_SCOCfgLoadingParent_Ver on CMPSCOCfgStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex; create index IDX_SCOCfgOwningFolder_Ver on CMPSCOCfgStorage (WorkspaceID, r_6) nologging compress tablespace %tndex; create index IDX_SCOCfgFCOClass_Ver on CMPSCOCfgStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex; create table CMPSCOMapStorage ( WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null, SnapshotID NUMBER(9) default 0, CompUOID VARCHAR2(255), isSeed NUMBER(1) default 1, active NUMBER(1) default 0, DeletionParent NUMBER(9), LoadingParent NUMBER(9), b_1 CHAR(1), b_2 CHAR(1), b_3 CHAR(1), b_4 CHAR(1), b_5 CHAR(1), b_6 CHAR(1), b_7 CHAR(1), b_8 CHAR(1), b_9 CHAR(1), b_10 CHAR(1), b_11 CHAR(1), i_1 NUMBER(9), i_2 NUMBER(9), i_3 NUMBER(9), i_4 NUMBER(9), i_5 NUMBER(9), i_6 NUMBER(9), i_7 NUMBER(9), i_8 NUMBER(9), i_9 NUMBER(9), i_10 NUMBER(9), i_11 NUMBER(9), i_12 NUMBER(9), i_13 NUMBER(9), d_1 DATE, d_2 DATE, t_1 TIMESTAMP, t_2 TIMESTAMP, t_3 TIMESTAMP, t_4 TIMESTAMP, t_5 TIMESTAMP, t_6 TIMESTAMP, t_7 TIMESTAMP, t_8 TIMESTAMP, t_9 TIMESTAMP, t_10 TIMESTAMP, t_11 TIMESTAMP, t_12 TIMESTAMP, t_13 TIMESTAMP, s1_1 VARCHAR2(40), s1_2 VARCHAR2(40), s1_3 VARCHAR2(40), s1_4 VARCHAR2(40), s1_5 VARCHAR2(40), s1_6 VARCHAR2(40), s1_7 VARCHAR2(40), s1_8 VARCHAR2(40), s1_9 VARCHAR2(40), s1_10 VARCHAR2(40), s2_1 VARCHAR2(255), s2_2 VARCHAR2(255), s2_3 VARCHAR2(255), s4_1 VARCHAR2(1000), s4_2 VARCHAR2(1000), s3_1 VARCHAR2(4000), s3_2 VARCHAR2(4000), s3_3 VARCHAR2(4000), s3_4 VARCHAR2(4000), s3_5 VARCHAR2(4000), s3_6 VARCHAR2(4000), s3_7 VARCHAR2(4000), s3_8 VARCHAR2(4000), s3_9 VARCHAR2(4000), s3_10 VARCHAR2(4000), s3_11 VARCHAR2(4000), s3_12 VARCHAR2(4000), cl_1 CLOB, cl_2 CLOB, r_1 NUMBER(9), r_2 NUMBER(9), r_3 NUMBER(9), r_4 NUMBER(9), r_5 NUMBER(9), r_6 NUMBER(9), r_7 NUMBER(9), r_8 NUMBER(9), r_9 NUMBER(9), r_10 NUMBER(9), r_11 NUMBER(9), r_12 NUMBER(9), r_13 NUMBER(9), r_14 NUMBER(9), r_15 NUMBER(9), r_16 NUMBER(9), r_17 NUMBER(9), r_18 NUMBER(9), r_19 NUMBER(9) ) TABLESPACE %snapshot_store_ts; create unique index IDX_SCOMapELEMENTID_VER on CMPSCOMapStorage ( WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex; alter table CMPSCOMapStorage nologging add constraint IDX_SCOMapELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID); create index IDX_SCOMapSNAPID_Ver on CMPSCOMapStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex; create index IDX_SCOMapCompUOID_Ver on CMPSCOMapStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex; create index IDX_SCOMapUOID_Ver on CMPSCOMapStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex; create index IDX_SCOMapActiveClassName_Ver on CMPSCOMapStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex; create index IDX_SCOMapLoadingParent_Ver on CMPSCOMapStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex; create index IDX_SCOMapOwningFolder_Ver on CMPSCOMapStorage (WorkspaceID, r_6) nologging compress tablespace %tndex; create index IDX_SCOMapFCOClass_Ver on CMPSCOMapStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex; create table CMPSCOPrpStorage ( WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null, SnapshotID NUMBER(9) default 0, CompUOID VARCHAR2(255), isSeed NUMBER(1) default 1, active NUMBER(1) default 0, DeletionParent NUMBER(9), LoadingParent NUMBER(9), b_1 CHAR(1), b_2 CHAR(1), b_3 CHAR(1), b_4 CHAR(1), b_5 CHAR(1), b_6 CHAR(1), b_7 CHAR(1), b_8 CHAR(1), b_9 CHAR(1), b_10 CHAR(1), b_11 CHAR(1), i_1 NUMBER(9), i_2 NUMBER(9), i_3 NUMBER(9), i_4 NUMBER(9), i_5 NUMBER(9), i_6 NUMBER(9), i_7 NUMBER(9), d_1 DATE, d_2 DATE, t_1 TIMESTAMP, t_2 TIMESTAMP, t_3 TIMESTAMP, t_4 TIMESTAMP, t_5 TIMESTAMP, t_6 TIMESTAMP, t_7 TIMESTAMP, t_8 TIMESTAMP, t_9 TIMESTAMP, t_10 TIMESTAMP, t_11 TIMESTAMP, s1_1 VARCHAR2(40), s1_2 VARCHAR2(40), s1_3 VARCHAR2(40), s1_4 VARCHAR2(40), s1_5 VARCHAR2(40), s1_6 VARCHAR2(40), s1_7 VARCHAR2(40), s1_8 VARCHAR2(40), s1_9 VARCHAR2(40), s2_1 VARCHAR2(255), s2_2 VARCHAR2(255), s2_3 VARCHAR2(255), s4_1 VARCHAR2(1000), s4_2 VARCHAR2(1000), s3_1 VARCHAR2(4000), s3_2 VARCHAR2(4000), s3_3 VARCHAR2(4000), s3_4 VARCHAR2(4000), s3_5 VARCHAR2(4000), s3_6 VARCHAR2(4000), s3_7 VARCHAR2(4000), cl_1 CLOB, cl_2 CLOB, cl_3 CLOB, r_1 NUMBER(9), r_2 NUMBER(9), r_3 NUMBER(9), r_4 NUMBER(9), r_5 NUMBER(9), r_6 NUMBER(9), r_7 NUMBER(9), r_8 NUMBER(9), r_9 NUMBER(9), r_10 NUMBER(9), r_11 NUMBER(9), r_12 NUMBER(9), r_13 NUMBER(9), r_14 NUMBER(9), r_15 NUMBER(9), r_16 NUMBER(9) ) TABLESPACE %snapshot_store_ts; create unique index IDX_SCOPrpELEMENTID_VER on CMPSCOPrpStorage ( WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex; alter table CMPSCOPrpStorage nologging add constraint IDX_SCOPrpELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID); create index IDX_SCOPrpSNAPID_Ver on CMPSCOPrpStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex; create index IDX_SCOPrpCompUOID_Ver on CMPSCOPrpStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex; create index IDX_SCOPrpUOID_Ver on CMPSCOPrpStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex; create index IDX_SCOPrpActiveClassName_Ver on CMPSCOPrpStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex; create index IDX_SCOPrpLoadingParent_Ver on CMPSCOPrpStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex; create index IDX_SCOPrpOwningFolder_Ver on CMPSCOPrpStorage (WorkspaceID, r_6) nologging compress tablespace %tndex; create index IDX_SCOPrpFCOClass_Ver on CMPSCOPrpStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex; create table CMPSYSStorage ( WorkspaceID NUMBER(9) default 1 not null, SnapshotID NUMBER(9) default 0, CompUOID VARCHAR2(255), isSeed NUMBER(1) default 1, active NUMBER(1) default 0, DeletionParent NUMBER(9), LoadingParent NUMBER(9), b_1 CHAR(1), b_2 CHAR(1), b_3 CHAR(1), b_4 CHAR(1), b_5 CHAR(1), b_6 CHAR(1), b_7 CHAR(1), b_8 CHAR(1), b_9 CHAR(1), b_10 CHAR(1), b_11 CHAR(1), b_12 CHAR(1), i_1 NUMBER(9), i_2 NUMBER(9), i_3 NUMBER(9), i_4 NUMBER(9), i_5 NUMBER(9), i_6 NUMBER(9), i_7 NUMBER(9), d_1 DATE, d_2 DATE, d_3 DATE, t_1 TIMESTAMP, t_2 TIMESTAMP, t_3 TIMESTAMP, t_4 TIMESTAMP, t_5 TIMESTAMP, t_6 TIMESTAMP, t_7 TIMESTAMP, t_8 TIMESTAMP, t_9 TIMESTAMP, s1_1 VARCHAR2(40), s1_2 VARCHAR2(40), s1_3 VARCHAR2(40), s1_4 VARCHAR2(40), s1_5 VARCHAR2(40), s1_6 VARCHAR2(40), s1_7 VARCHAR2(40), s1_8 VARCHAR2(40), s1_9 VARCHAR2(40), s1_10 VARCHAR2(40), s1_11 VARCHAR2(40), s2_1 VARCHAR2(255), s2_2 VARCHAR2(255), s2_3 VARCHAR2(255), s4_1 VARCHAR2(1000), s4_2 VARCHAR2(1000), s3_1 VARCHAR2(4000), s3_2 VARCHAR2(4000), s3_3 VARCHAR2(4000), s3_4 VARCHAR2(4000), s3_5 VARCHAR2(4000), s3_6 VARCHAR2(4000), cl_1 CLOB, cl_2 CLOB, bl_1 BLOB, r_1 NUMBER(9), r_2 NUMBER(9), r_3 NUMBER(9), r_4 NUMBER(9), r_5 NUMBER(9), r_6 NUMBER(9), r_7 NUMBER(9), r_8 NUMBER(9), r_9 NUMBER(9), r_10 NUMBER(9), r_11 NUMBER(9), r_12 NUMBER(9), r_13 NUMBER(9), r_14 NUMBER(9), r_15 NUMBER(9) ) TABLESPACE %snapshot_store_ts; create unique index IDX_SYSELEMENTID_VER on CMPSYSStorage ( WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex; alter table CMPSYSStorage nologging add constraint IDX_SYSELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID); create index IDX_SYSSNAPID_Ver on CMPSYSStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex; create index IDX_SYSCompUOID_Ver on CMPSYSStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex; create index IDX_SYSUOID_Ver on CMPSYSStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex; create index IDX_SYSActiveClassName_Ver on CMPSYSStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex; create index IDX_SYSLoadingParent_Ver on CMPSYSStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex; create index IDX_SYSOwningFolder_Ver on CMPSYSStorage (WorkspaceID, r_6) nologging compress tablespace %tndex; create index IDX_SYSFCOClass_Ver on CMPSYSStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de