REM
REM  MODIFIED
REM   jkundu    03/30/09 - add logmnr_gt_xid_include
REM   matfarre  12/09/08 - bug 7596712: add session actions table
REM   dvoss     11/07/08 - bug 7480265 - sequences should not be cached
REM   dvoss     10/02/08 - convert integers to numbers
REM   qiwang    04/02/07 - BUG 5743875: memory spill/privatelcrList
REM   mtao      03/29/07 - bug 5880925: add version_timestamp to global$
REM   mtao      03/03/07 - bug 5903103: Rename logical remote logs to foreign
REM   dvoss     01/03/07 - creation
REM
CREATE TABLE system.logmnr_session_evolve$ (
      branch_level            number,
      session#                number,
      db_id                   number,
      reset_scn               number,
      reset_timestamp         number,
      prev_reset_scn          number,
      prev_reset_timestamp    number,
      status                  number,
      spare1                  number,
      spare2                  number,
      spare3                  number,
      spare4                  date,
      CONSTRAINT LOGMNR_SESSION_EVOLVE$_PK PRIMARY KEY 
        (SESSION#, DB_ID, RESET_SCN, RESET_TIMESTAMP)
        USING INDEX TABLESPACE SYSAUX LOGGING)
  tablespace SYSAUX LOGGING
/
CREATE SEQUENCE system.logmnr_evolve_seq$ START WITH 1
       INCREMENT BY 1 NOMAXVALUE ORDER NOCACHE
/
CREATE SEQUENCE system.logmnr_seq$ ORDER NOCACHE
/
CREATE SEQUENCE system.logmnr_uids$ START WITH 100
       INCREMENT BY 1 NOMAXVALUE ORDER NOCACHE
/
CREATE TABLE system.logmnr_global$ (
      high_recid_foreign      number, 
      high_recid_deleted      number, 
      local_reset_scn         number,
      local_reset_timestamp   number,
      version_timestamp       number,
      spare1                  number,
      spare2                  number,
      spare3                  number,
      spare4                  varchar2(2000),
      spare5                  date)
   tablespace SYSAUX LOGGING
/
CREATE GLOBAL TEMPORARY TABLE system.logmnr_gt_tab_include$ (
	schema_name            varchar2(32),
        table_name             varchar2(32)
        ) on commit preserve rows
/
CREATE GLOBAL TEMPORARY TABLE system.logmnr_gt_user_include$ (
                user_name            varchar2(32),
                user_type            number  /* 0 DB_USER, 1 OS_USER */
                ) on commit preserve rows
/
CREATE GLOBAL TEMPORARY TABLE system.logmnr_gt_xid_include$ (
		xidusn   number,
		xidslt   number,
		xidsqn   number
                ) on commit preserve rows
/
CREATE TABLE SYSTEM.LOGMNR_UID$ (
                    LOGMNR_UID  NUMBER(22),
                    SESSION#    NUMBER CONSTRAINT LOGMNR_UID$_PK 
                      PRIMARY KEY)  TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYS.LOGMNR_BUILDLOG (
                    INITIAL_XID VARCHAR2(22) CONSTRAINT LOGMNR_BUILDLOG_PK
                      PRIMARY KEY,
                    BUILD_DATE VARCHAR2(20),
                    DB_TXN_SCNBAS NUMBER,
                    DB_TXN_SCNWRP NUMBER,
                    CURRENT_BUILD_STATE NUMBER,
                    COMPLETION_STATUS NUMBER,
                    MARKED_LOG_FILE_LOW_SCN NUMBER)
                    TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYSTEM.LOGMNRC_DBNAME_UID_MAP(
                      GLOBAL_NAME        VARCHAR2(128) NOT NULL,
                        CONSTRAINT LOGMNRC_DBNAME_UID_MAP_PK
                        PRIMARY KEY(GLOBAL_NAME),
                      LOGMNR_UID         NUMBER,
                      FLAGS              NUMBER ) 
                      TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.LOGMNR_LOG$ (
              session#        number,
              thread#         number,
              sequence#       number,
              first_change#   number,
              next_change#    number,
              first_time      date,
              next_time       date,
              file_name       varchar2(513),
              status          number,
              info            varchar2(32),
              timestamp       date,
              dict_begin      varchar2(3),
              dict_end        varchar2(3),
              status_info     varchar2(32),
              db_id                  number,
              resetlogs_change#      number,
              reset_timestamp        number,
              prev_resetlogs_change# number,
              prev_reset_timestamp   number,
              blocks                 number,
              block_size             number,
              flags                  number,
              contents               number,
              recid                  number,
              recstamp               number,
              mark_delete_timestamp  number,
              spare1                 number,
              spare2                 number,
              spare3                 number,
              spare4                 number,
              spare5                 number,
              CONSTRAINT LOGMNR_LOG$_PK PRIMARY KEY 
                (SESSION#, THREAD#, SEQUENCE#, FIRST_CHANGE#,
                 DB_ID, RESETLOGS_CHANGE#, RESET_TIMESTAMP)
                USING INDEX TABLESPACE SYSAUX LOGGING)
           TABLESPACE SYSAUX LOGGING
/
CREATE INDEX system.logmnr_log$_flags ON 
        system.logmnr_log$(flags) 
        TABLESPACE SYSAUX LOGGING
/
CREATE INDEX system.logmnr_log$_first_change# ON 
        system.logmnr_log$(first_change#) 
        TABLESPACE SYSAUX LOGGING
/
CREATE INDEX system.logmnr_log$_recid ON 
        system.logmnr_log$(recid) 
        TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.logmnr_processed_log$ (
              session#        number,
              thread#         number,
              sequence#       number,
              first_change#   number,
              next_change#    number,
              first_time      date,
              next_time       date,
              file_name       varchar2(513),
              status          number,
              info            varchar2(32),
              timestamp       date,
              CONSTRAINT LOGMNR_PROCESSED_LOG$_PK PRIMARY KEY
                (SESSION#, THREAD#)
                USING INDEX TABLESPACE SYSAUX LOGGING)
            TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.logmnr_spill$ (
                session#     number,
                xidusn       number,
                xidslt       number,
                xidsqn       number,
                chunk        number,
                startidx     number,
                endidx       number,
                flag         number,  
                sequence#    number,
                spill_data   blob,
                spare1     number,
                spare2     number,
                CONSTRAINT LOGMNR_SPILL$_PK PRIMARY KEY
                 (session#, xidusn, xidslt, xidsqn, chunk, 
                  startidx, endidx, flag, sequence#)
                  USING INDEX TABLESPACE SYSAUX LOGGING)
            LOB (spill_data)
              STORE AS (TABLESPACE SYSAUX CACHE LOGGING PCTVERSION 0
                        CHUNK 16k STORAGE (INITIAL 16K NEXT 16K))
            TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.logmnr_age_spill$ (
           session#     number,
           xidusn       number,
           xidslt       number,
           xidsqn       number,
           chunk        number, 
           sequence#    number,
           offset       number,  
           spill_data   blob,
           spare1     number,
           spare2     number,
           CONSTRAINT LOGMNR_AGE_SPILL$_PK PRIMARY KEY
             (session#, xidusn, xidslt, xidsqn, chunk, sequence#)
             USING INDEX TABLESPACE SYSAUX LOGGING)
       LOB (spill_data) STORE AS (TABLESPACE SYSAUX CACHE PCTVERSION 0
                                  CHUNK 16k STORAGE (INITIAL 16K NEXT 16K))
       TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.logmnr_restart_ckpt_txinfo$ (
             session#     number,
             xidusn       number,
             xidslt       number,
             xidsqn       number,
             session_num  number,
             serial_num   number,
             flag         number,
             start_scn    number,
             effective_scn number,
             offset       number,  
             tx_data      blob,
             CONSTRAINT LOGMNR_RESTART_CKPT_TXINFO$_PK PRIMARY KEY 
                (session#, xidusn, xidslt, xidsqn,
                 session_num, serial_num, effective_scn)
                USING INDEX TABLESPACE SYSAUX LOGGING)
         LOB (tx_data) STORE AS (TABLESPACE SYSAUX CACHE PCTVERSION 0
                                 CHUNK 16k STORAGE (INITIAL 16K NEXT 16K))
         TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.LOGMNR_ERROR$ (
              session#        number,
              time_of_error   date,
              code            number,
              message         varchar2(4000),
              spare1          number,
              spare2          number,
              spare3          number,
              spare4          varchar2(4000),
              spare5          varchar2(4000))
           TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.LOGMNR_RESTART_CKPT$ (
              session#     number,
              valid        number,
              ckpt_scn     number,
              xidusn       number,
              xidslt       number,
              xidsqn       number,
              session_num  number,
              serial_num   number,
              ckpt_info    blob,
              flag         number,
              offset       number,  
              client_data  blob,
              spare1       number,
              spare2       number,
     CONSTRAINT LOGMNR_RESTART_CKPT$_PK PRIMARY KEY 
        (session#, ckpt_scn, xidusn, xidslt, xidsqn, session_num, serial_num))
   LOB (ckpt_info, client_data)
       STORE AS (TABLESPACE SYSAUX CACHE PCTVERSION 0
                 CHUNK 16k STORAGE (INITIAL 16K NEXT 16K))
   TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.LOGMNR_FILTER$ (
                session#                number,
                filter_type             varchar2(30),
                attr1                   number,
                attr2                   number,
                attr3                   number,
                attr4                   number,
                attr5                   number,
                attr6                   number,
                filter_scn              number,
                spare1                  number,
                spare2                  number,
                spare3                  date)
            TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.LOGMNR_SESSION_ACTIONS$ (
                /* Non Initial Attributes  */
                FlagsRunTime     number default 0, /* FLAGSM_SET_KRVUSA */
                DropSCN          number,
                ModifyTime       timestamp,
                DispatchTime     timestamp,
                DropTime         timestamp,
                LCRCount         number default 0,
                /* Initial Attibutes        */
                ActionName       varchar2(30) NOT NULL,
                LogmnrSession#   number NOT NULL,
                ProcessRole#     number NOT NULL,
                ActionType#      number NOT NULL,
                FlagsDefineTime  number,
                CreateTime       timestamp,
                XIDusn           number,
                XIDslt           number,
                XIDsqn           number,
                Thread#          number,
                StartSCN         number,
                StartSubSCN      number,
                EndSCN           number,
                EndSubSCN        number,
                RBAsqn           number,
                RBAblk           number,
                RBAbyte          number,
                Session#         number,
                Obj#             number,
                attr1            number,
                attr2            number,
                attr3            number,
                spare1           number,
                spare2           number,
                spare3           timestamp,
                spare4           varchar2(2000),
              CONSTRAINT LOGMNR_SESSION_ACTION$_PK
                PRIMARY KEY (LogmnrSession#, ActionName)
                USING INDEX TABLESPACE SYSAUX LOGGING enable)
            TABLESPACE SYSAUX LOGGING
/
CREATE TABLE SYSTEM.LOGMNR_PARAMETER$ (
                session#        number not null,
                name            varchar2(30) not null,
                value           varchar2(2000),
                type            number,
                scn             number,
                spare1          number,
                spare2          number,
                spare3          varchar2(2000))
            TABLESPACE SYSTEM LOGGING
/
CREATE INDEX SYSTEM.LOGMNR_PARAMETER_INDX ON 
                SYSTEM.LOGMNR_PARAMETER$(SESSION#, name) 
            TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYSTEM.LOGMNR_SESSION$ (
          session#                number,
          client#                 number,
          session_name            varchar2(128) not null,
          db_id                   number,
          resetlogs_change#       number,
          session_attr            number,
          session_attr_verbose    varchar2(400),
          start_scn               number,
          end_scn                 number,
          spill_scn               number,
          spill_time              date,
          oldest_scn              number,
          resume_scn              number,
          global_db_name          varchar2(128) default null,
          reset_timestamp         number,
          branch_scn              number,
          version                 varchar2(64),
          redo_compat             varchar2(20),
          spare1                  number,
          spare2                  number,
          spare3                  number,
          spare4                  number,
          spare5                  number,
          spare6                  date,
          spare7                  varchar2(1000),
          spare8                  varchar2(1000),
     constraint logmnr_session_pk primary key (session#)
          using index tablespace SYSTEM logging,
     constraint logmnr_session_uk1 unique (session_name)
          using index tablespace SYSTEM logging enable validate)
   tablespace SYSTEM logging
/
CREATE TABLE SYS.LOGMNRG_SEED$ (
      SEED_VERSION NUMBER(22),
      GATHER_VERSION NUMBER(22),
      SCHEMANAME VARCHAR2(30),
      OBJ# NUMBER,
      OBJV# NUMBER(22),
      TABLE_NAME VARCHAR2(30),
      COL_NAME VARCHAR2(30),
      COL# NUMBER,
      INTCOL# NUMBER,
      SEGCOL# NUMBER,
      TYPE# NUMBER,
      LENGTH NUMBER,
      PRECISION# NUMBER,
      SCALE NUMBER,
      NULL$ NUMBER NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_DICTIONARY$ (
      DB_NAME VARCHAR2(9),
      DB_ID NUMBER(20),
      DB_CREATED VARCHAR2(20),
      DB_DICT_CREATED VARCHAR2(20),
      DB_DICT_SCN NUMBER(22),
      DB_THREAD_MAP RAW(8),
      DB_TXN_SCNBAS NUMBER(22),
      DB_TXN_SCNWRP NUMBER(22),
      DB_RESETLOGS_CHANGE# NUMBER(22),
      DB_RESETLOGS_TIME VARCHAR2(20),
      DB_VERSION_TIME VARCHAR2(20),
      DB_REDO_TYPE_ID VARCHAR2(8),
      DB_REDO_RELEASE VARCHAR2(60),
      DB_CHARACTER_SET VARCHAR2(30),
      DB_VERSION VARCHAR2(64),
      DB_STATUS VARCHAR2(64),
      DB_GLOBAL_NAME VARCHAR(128),
      DB_DICT_MAXOBJECTS NUMBER(22),
      DB_DICT_OBJECTCOUNT NUMBER(22) NOT NULL  ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_OBJ$ (
      OBJV# NUMBER(22),
      OWNER# NUMBER(22),
      NAME VARCHAR2(30),
      NAMESPACE NUMBER(22),
      SUBNAME VARCHAR2(30),
      TYPE# NUMBER(22),
      OID$  RAW(16),
      REMOTEOWNER VARCHAR2(30),
      LINKNAME VARCHAR(128),
      FLAGS NUMBER(22),
      SPARE3 NUMBER(22),
      STIME DATE,
      OBJ# NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_TAB$ (
      TS# NUMBER(22),
      COLS NUMBER(22),
      PROPERTY NUMBER(22),
      INTCOLS NUMBER(22),
      KERNELCOLS NUMBER(22),
      BOBJ# NUMBER(22),
      TRIGFLAG NUMBER(22),
      FLAGS NUMBER(22),
      OBJ# NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_COL$ (
      COL# NUMBER(22),
      SEGCOL# NUMBER(22),
      NAME VARCHAR2(30),
      TYPE# NUMBER(22),
      LENGTH NUMBER(22),
      PRECISION# NUMBER(22),
      SCALE NUMBER(22),
      NULL$ NUMBER(22),
      INTCOL# NUMBER(22),
      PROPERTY NUMBER(22),
      CHARSETID NUMBER(22),
      CHARSETFORM NUMBER(22),
      SPARE1 NUMBER(22),
      SPARE2 NUMBER(22),
      OBJ# NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_ATTRCOL$ (
      INTCOL#   number,
      NAME      varchar2(4000),
      OBJ#      number NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_TS$ (
      TS# NUMBER(22),
      NAME VARCHAR2(30),
      OWNER# NUMBER(22),
      BLOCKSIZE NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_IND$ (
     BO#     NUMBER(22),
     COLS     NUMBER(22),
     TYPE#    NUMBER(22),
     FLAGS    NUMBER,
     PROPERTY NUMBER,
     OBJ#     NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_USER$ (
      USER# NUMBER(22),
      NAME VARCHAR2(30) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_TABPART$ (
      OBJ# NUMBER(22),
      TS# NUMBER(22),
      PART# NUMBER,
      BO# NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_TABSUBPART$ (
      OBJ# NUMBER(22),
      DATAOBJ# NUMBER(22),
      POBJ# NUMBER(22),
      SUBPART# NUMBER(22),
      TS# NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_TABCOMPART$ (
      OBJ# NUMBER(22),
      BO# NUMBER(22),
      PART# NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_TYPE$ (
      version# number,
      version varchar2(30),
      tvoid raw(16),
      typecode number,
      properties number,
      attributes number,
      methods number,
      hiddenMethods number,
      supertypes number,
      subtypes number,
      externtype number,
      externname varchar2(4000),
      helperclassname varchar2(4000),
      local_attrs number,
      local_methods number,
      typeid raw(16),
      roottoid raw(16),
      spare1 number,
      spare2 number,
      spare3 number,
      supertoid raw(16),
      hashcode raw(17),
      toid raw(16) not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_COLTYPE$ (
      col# number,
      intcol# number,
      toid raw(16),
      version# number,
      packed number,
      intcols number,
      intcol#s raw(2000),
      flags number,
      typidcol# number,
      synobj# number,
      obj# number not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_ATTRIBUTE$ (
      version#      number,
      name          varchar2(30),
      attribute#    number,
      attr_toid     raw(16),
      attr_version# number,
      synobj#       number,
      properties    number,
      charsetid     number,
      charsetform   number,
      length        number,
      precision#    number,
      scale         number,
      externname    varchar2(4000),
      xflags        number,
      spare1        number,
      spare2        number,
      spare3        number,
      spare4        number,
      spare5        number,
      setter        number,
      getter        number,
      toid          raw(16) not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_LOB$ (
      OBJ#          NUMBER,
      INTCOL#       NUMBER,
      COL#          NUMBER,
      LOBJ#         NUMBER,
      CHUNK         NUMBER NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_CDEF$ (
      CON#          NUMBER,
      COLS          NUMBER,
      TYPE#         NUMBER,
      ROBJ#         NUMBER, 
      RCON#         NUMBER, 
      ENABLED       NUMBER,
      DEFER         NUMBER,
      OBJ#          NUMBER NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_CCOL$ (
      CON#          NUMBER,
      OBJ#          NUMBER,
      COL#          NUMBER,
      POS#          NUMBER,
      INTCOL#       NUMBER NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_ICOL$ (
      OBJ#          NUMBER,
      BO#           NUMBER,
      COL#          NUMBER,
      POS#          NUMBER,
      SEGCOL#       NUMBER,
      INTCOL#       NUMBER NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_LOBFRAG$ (
      FRAGOBJ#      NUMBER,
      PARENTOBJ#    NUMBER,
      TABFRAGOBJ#   NUMBER,
      INDFRAGOBJ#   NUMBER,
      FRAG#         NUMBER NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_INDPART$ (
      OBJ# NUMBER,
      BO#  NUMBER,
      PART# NUMBER,
      TS#  NUMBER NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_INDSUBPART$ (
      OBJ# NUMBER(22),
      DATAOBJ# NUMBER(22),
      POBJ# NUMBER(22),
      SUBPART# NUMBER(22),
      TS# NUMBER(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_INDCOMPART$ (
      OBJ#     NUMBER,
      DATAOBJ# NUMBER,
      BO#      NUMBER,
      PART#    NUMBER NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_LOGMNR_BUILDLOG (
       BUILD_DATE VARCHAR2(20),
       DB_TXN_SCNBAS NUMBER,
       DB_TXN_SCNWRP NUMBER,
       CURRENT_BUILD_STATE NUMBER,
       COMPLETION_STATUS NUMBER,
       MARKED_LOG_FILE_LOW_SCN NUMBER,
       INITIAL_XID VARCHAR2(22) NOT NULL ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_NTAB$ (
       col# number,
       intcol# number,
       ntab# number,
       name varchar2(4000),
       obj# number not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_OPQTYPE$ (
       intcol# number not null,
       type number,
       flags number,
       lobcol number,
       objcol number,
       extracol number,
       schemaoid raw(16),
       elemnum number,
       schemaurl varchar2(4000),
       obj# number not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_SUBCOLTYPE$ (
       intcol# number not null,
       toid raw(16) not null,
       version# number not null,
       intcols number,
       intcol#s raw(2000),
       flags number,
       synobj# number,
       obj# number not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_KOPM$ (
       length number,
       metadata raw(255),
       name varchar2(30) not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_PROPS$ (
       value$ varchar2(4000),
       comment$ varchar2(4000),
       name varchar2(30) not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_ENC$ (
       obj# number,
       owner# number,
       encalg number,
       intalg number,
       colklc raw(2000),
       klclen number,
       flag number,
       mkeyid varchar2(64) not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_REFCON$ (
       col#     number,
       intcol#  number,
       reftyp   number,
       stabid   raw(16),
       expctoid raw(16),
       obj#     number not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE TABLE SYS.LOGMNRG_PARTOBJ$ (
      parttype    number,
       partcnt     number,
       partkeycols number,
       flags       number,
       defts#      number,
       defpctfree  number,
       defpctused  number,
       defpctthres number,
       definitrans number,
       defmaxtrans number,
       deftiniexts number,
       defextsize  number,
       defminexts  number,
       defmaxexts  number,
       defextpct   number,
       deflists    number,
       defgroups   number,
       deflogging  number,
       spare1      number,
       spare2      number,
       spare3      number,
       definclcol  number,
       parameters  varchar2(1000),
       obj#        number not null ) 
   TABLESPACE SYSTEM LOGGING
/
CREATE GLOBAL TEMPORARY TABLE system.logmnrt_mddl$ (
                  source_obj#     NUMBER,
                  source_rowid    ROWID,
                  dest_rowid      ROWID NOT NULL,
                    CONSTRAINT logmnrt_mddl$_pk
                      PRIMARY KEY(source_obj#, source_rowid)
                  ) on commit delete rows
/