rem Generated for Warehouse Builder by cwmgen

create sequence cwmseq start with 10000 increment by 10;

create sequence cwmWorkspaceSeq start with 2 increment by 1;

create table CMPFCOClasses
(
    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)
);

alter table CMPFCOClasses
  modify r_6 default 0;

create unique index IDX_FCOELEMENTID on CMPFCOClasses (
WorkspaceID, i_1) nologging compress tablespace %tndex;
alter table CMPFCOClasses nologging
 add constraint IDX_FCOELEMENTID primary key (WorkspaceID, i_1);
   create index IDX_FCOUOID on CMPFCOClasses (WorkspaceID, s1_2) parallel nologging compress tablespace %tndex;
   create index IDX_FCOClassNameElemId on CMPFCOClasses (WorkspaceID, s2_1, i_1) parallel nologging compress tablespace %tndex;
   create index IDX_FCOOwningFolder on CMPFCOClasses (WorkspaceID, r_6) parallel nologging compress tablespace %tndex;
   create index IDX_FCONAME on CMPFCOClasses (WorkspaceID, s4_2, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_FCOLogicalObject on CMPFCOClasses (WorkspaceID, r_15, s2_1) parallel nologging compress tablespace %tndex;
create table CMPMMMClasses
(
    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)
);

create table CMPSCOClasses
(
    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)
);

create unique index IDX_SCOELEMENTID on CMPSCOClasses (
WorkspaceID, i_1) nologging compress tablespace %tndex;
alter table CMPSCOClasses nologging
 add constraint IDX_SCOELEMENTID primary key (WorkspaceID, i_1);
   create index IDX_SCOUOID on CMPSCOClasses (WorkspaceID, s1_2) parallel nologging compress tablespace %tndex;
   create index IDX_SCOClassNameElemId on CMPSCOClasses (WorkspaceID, s2_1, i_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOFCOClass on CMPSCOClasses (WorkspaceID, r_7, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCONAME on CMPSCOClasses (WorkspaceID, s4_2, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOITEMSET on CMPSCOClasses (WorkspaceID, r_17, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOTRANSLATABLE on CMPSCOClasses (WorkspaceID, r_15, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOFCORef on CMPSCOClasses (WorkspaceID, r_16, s2_1) parallel nologging compress tablespace %tndex;
create table CMPSCOCfgClasses
(
    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)
);

create unique index IDX_SCOCfgELEMENTID on CMPSCOCfgClasses (
WorkspaceID, i_1) nologging compress tablespace %tndex;
alter table CMPSCOCfgClasses nologging
 add constraint IDX_SCOCfgELEMENTID primary key (WorkspaceID, i_1);
   create index IDX_SCOCfgUOID on CMPSCOCfgClasses (WorkspaceID, s1_2) parallel nologging compress tablespace %tndex;
   create index IDX_SCOCfgClassNameElemId on CMPSCOCfgClasses (WorkspaceID, s2_1, i_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOCfgFCOClass on CMPSCOCfgClasses (WorkspaceID, r_7, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOCfgDIMENSION on CMPSCOCfgClasses (WorkspaceID, r_17, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOCfgNAME on CMPSCOCfgClasses (WorkspaceID, s4_2, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOCfgOWNINGRELATION on CMPSCOCfgClasses (WorkspaceID, r_16, s2_1) parallel nologging compress tablespace %tndex;
create table CMPSCOMapClasses
(
    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)
);

create unique index IDX_SCOMapELEMENTID on CMPSCOMapClasses (
WorkspaceID, i_1) nologging compress tablespace %tndex;
alter table CMPSCOMapClasses nologging
 add constraint IDX_SCOMapELEMENTID primary key (WorkspaceID, i_1);
   create index IDX_SCOMapUOID on CMPSCOMapClasses (WorkspaceID, s1_2) parallel nologging compress tablespace %tndex;
   create index IDX_SCOMapClassNameElemId on CMPSCOMapClasses (WorkspaceID, s2_1, i_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOMapFCOClass on CMPSCOMapClasses (WorkspaceID, r_7, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOMapMAPATTR on CMPSCOMapClasses (WorkspaceID, r_19, s2_1) parallel nologging compress tablespace %tndex;
   create synonym IDX_SCOMapMAPOP for IDX_SCOMapMAPATTR;
   create index IDX_SCOMapMAPOPREF on CMPSCOMapClasses (WorkspaceID, r_16, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOMapNAME on CMPSCOMapClasses (WorkspaceID, s4_2, s2_1) parallel nologging compress tablespace %tndex;
   create synonym IDX_SCOMapCONNECTFROM for IDX_SCOMapMAPOPREF;
create table CMPSCOPrpClasses
(
    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)
);

create unique index IDX_SCOPrpELEMENTID on CMPSCOPrpClasses (
WorkspaceID, i_1) nologging compress tablespace %tndex;
alter table CMPSCOPrpClasses nologging
 add constraint IDX_SCOPrpELEMENTID primary key (WorkspaceID, i_1);
   create index IDX_SCOPrpUOID on CMPSCOPrpClasses (WorkspaceID, s1_2) parallel nologging compress tablespace %tndex;
   create index IDX_SCOPrpClassNameElemId on CMPSCOPrpClasses (WorkspaceID, s2_1, i_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOPrpFCOClass on CMPSCOPrpClasses (WorkspaceID, r_7, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOPrpNAME on CMPSCOPrpClasses (WorkspaceID, s4_2, s2_1) parallel nologging compress tablespace %tndex;
   create index IDX_SCOPrpOwnerClassBusName on CMPSCOPrpClasses (WorkspaceID, r_15, s2_1, s4_1) parallel nologging compress tablespace %tndex;
create table CMPSYSClasses
(
    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)
);

create unique index IDX_SYSELEMENTID on CMPSYSClasses (
WorkspaceID, i_1) nologging compress tablespace %tndex;
alter table CMPSYSClasses nologging
 add constraint IDX_SYSELEMENTID primary key (WorkspaceID, i_1);
   create index IDX_SYSUOID on CMPSYSClasses (WorkspaceID, s1_2) parallel nologging compress tablespace %tndex;
   create index IDX_SYSClassNameElemId on CMPSYSClasses (WorkspaceID, s2_1, i_1) parallel nologging compress tablespace %tndex;
   create index IDX_SYSNAME on CMPSYSClasses (WorkspaceID, s4_2, s2_1) parallel nologging compress tablespace %tndex;