VIEW: SYS.REPCAT_REPCATLOG

Source

View Text - Preformatted

SELECT
    id,
    source,
    DECODE(status,
      0, 'READY',
      1, 'DO_CALLBACK',
      2, 'AWAIT_CALLBACK',
      3, 'ERROR',
         'UNDEFINED'),
    userid,
    timestamp,
    DECODE (role,
      'Y', 'MASTERDEF',
      'N', 'MASTER',
           'UNDEFINED'),
    master,
    DECODE(request,
      -1, 'WAITING',
       0, 'CREATE_MASTER_REPOBJECT',
       1, 'DROP_MASTER_REPSCHEMA',
       2, 'ADD_MASTER_DATABASE',
       3, 'ALTER_MASTER_REPOBJECT',
       4, 'DROP_MASTER_REPOBJECT',
       5, 'SUSPEND_MASTER_ACTIVITY',
       6, 'RESUME_MASTER_ACTIVITY',
       7, 'EXECUTE_DDL',
       8, 'GENERATE_REPLICATION_SUPPORT',
       9, 'GENERATE_SUPPORT_PHASE_1',
      10, 'GENERATE_SUPPORT_PHASE_2',
      11, 'ALTER_MASTER_PROPAGATION',
      12, 'END_PHASE_2',
      13, 'GENERATE_INTERNAL_PKG_SUPPORT',
      14, 'END_GEN_INTERNAL_PKG_SUPPORT',
      15, 'COPY_FLAVOR_DEFINITIONS',
      16, 'COMPILE_MASTER_REPOBJECT',
      17, 'RENAME_SHADOW_COLUMN_GROUP',
      18, 'PULL_EXTENSION',
      19, 'CONTROL_PROPAGATION',
      20, 'WAIT_FOR_NEW_SITES_TO_PREPARE',
      21, 'ADD_COLUMN_PHASE_1',
      22, 'ADD_COLUMN_PHASE_2',
      23, 'ADD_COLUMN_PHASE_3',
      24, 'ADD_COLUMN_PHASE_4',
      25, 'PREPARE_FOR_IMPORT',
          'UNDEFINED'),
    DECODE(oname, NULL, NULL, sname),
    oname,
    DECODE (type,
      -1, 'SNAPSHOT',
       0, 'UNDEFINED',
       1, 'INDEX',
       2, 'TABLE',
       4, 'VIEW',
       5, 'SYNONYM',
       6, 'SEQUENCE',
       7, 'PROCEDURE',
       8, 'FUNCTION',
       9, 'PACKAGE',
      11, 'PACKAGE BODY',
      12, 'TRIGGER',
      13, 'TYPE',
      14, 'TYPE BODY',
      32, 'INDEXTYPE',
      33, 'OPERATOR',
      --- -3, 'UPDATABLE SNAPSHOT',
          'UNDEFINED'),
    message,
    errnum,
    NVL(gname, sname)
  FROM system.repcat$_repcatlog

View Text - HTML Formatted

SELECT ID
, SOURCE
, DECODE(STATUS
, 0
, 'READY'
, 1
, 'DO_CALLBACK'
, 2
, 'AWAIT_CALLBACK'
, 3
, 'ERROR'
, 'UNDEFINED')
, USERID
, TIMESTAMP
, DECODE (ROLE
, 'Y'
, 'MASTERDEF'
, 'N'
, 'MASTER'
, 'UNDEFINED')
, MASTER
, DECODE(REQUEST
, -1
, 'WAITING'
, 0
, 'CREATE_MASTER_REPOBJECT'
, 1
, 'DROP_MASTER_REPSCHEMA'
, 2
, 'ADD_MASTER_DATABASE'
, 3
, 'ALTER_MASTER_REPOBJECT'
, 4
, 'DROP_MASTER_REPOBJECT'
, 5
, 'SUSPEND_MASTER_ACTIVITY'
, 6
, 'RESUME_MASTER_ACTIVITY'
, 7
, 'EXECUTE_DDL'
, 8
, 'GENERATE_REPLICATION_SUPPORT'
, 9
, 'GENERATE_SUPPORT_PHASE_1'
, 10
, 'GENERATE_SUPPORT_PHASE_2'
, 11
, 'ALTER_MASTER_PROPAGATION'
, 12
, 'END_PHASE_2'
, 13
, 'GENERATE_INTERNAL_PKG_SUPPORT'
, 14
, 'END_GEN_INTERNAL_PKG_SUPPORT'
, 15
, 'COPY_FLAVOR_DEFINITIONS'
, 16
, 'COMPILE_MASTER_REPOBJECT'
, 17
, 'RENAME_SHADOW_COLUMN_GROUP'
, 18
, 'PULL_EXTENSION'
, 19
, 'CONTROL_PROPAGATION'
, 20
, 'WAIT_FOR_NEW_SITES_TO_PREPARE'
, 21
, 'ADD_COLUMN_PHASE_1'
, 22
, 'ADD_COLUMN_PHASE_2'
, 23
, 'ADD_COLUMN_PHASE_3'
, 24
, 'ADD_COLUMN_PHASE_4'
, 25
, 'PREPARE_FOR_IMPORT'
, 'UNDEFINED')
, DECODE(ONAME
, NULL
, NULL
, SNAME)
, ONAME
, DECODE (TYPE
, -1
, 'SNAPSHOT'
, 0
, 'UNDEFINED'
, 1
, 'INDEX'
, 2
, 'TABLE'
, 4
, 'VIEW'
, 5
, 'SYNONYM'
, 6
, 'SEQUENCE'
, 7
, 'PROCEDURE'
, 8
, 'FUNCTION'
, 9
, 'PACKAGE'
, 11
, 'PACKAGE BODY'
, 12
, 'TRIGGER'
, 13
, 'TYPE'
, 14
, 'TYPE BODY'
, 32
, 'INDEXTYPE'
, 33
, 'OPERATOR'
, --- -3
, 'UPDATABLE SNAPSHOT'
, 'UNDEFINED')
, MESSAGE
, ERRNUM
, NVL(GNAME
, SNAME)
FROM SYSTEM.REPCAT$_REPCATLOG