SELECT
sname,
oname,
DECODE (type,
-1, 'SNAPSHOT',
1, 'INDEX',
2, 'TABLE',
4, 'VIEW',
5, 'SYNONYM',
6, 'SEQUENCE',
7, 'PROCEDURE',
8, 'FUNCTION',
9, 'PACKAGE',
11, 'PACKAGE BODY',
12, 'TRIGGER',
--- -3, 'UPDATABLE SNAPSHOT',
'UNDEFINED'),
DECODE (reason,
0, 'REPLICATION TRIGGER',
1, 'REPLICATION PACKAGE',
2, 'RESOLUTION PACKAGE',
3, 'PRIORITY PACKAGE',
4, 'AUDIT PACKAGE',
5, 'PROCEDURAL REPLICATION WRAPPER',
6, 'TRIGGER PACKAGE',
7, 'MIXED REPLICATION TRIGGER',
8, 'MIXED REPLICATION WRAPPER',
9, 'LOB PACKAGE',
10, 'REPLICATION UPDATE PACKAGE',
'UNDEFINED'),
base_sname,
base_oname,
DECODE (base_type,
-1, 'SNAPSHOT',
1, 'INDEX',
2, 'TABLE',
4, 'VIEW',
5, 'SYNONYM',
6, 'SEQUENCE',
7, 'PROCEDURE',
8, 'FUNCTION',
9, 'PACKAGE',
11, 'PACKAGE BODY',
12, 'TRIGGER',
--- -3, 'UPDATABLE SNAPSHOT',
'UNDEFINED'),
package_prefix,
procedure_prefix,
distributed
FROM system.repcat$_generated
SELECT
SNAME
,
ONAME
,
DECODE (TYPE
,
-1
, 'SNAPSHOT'
,
1
, 'INDEX'
,
2
, 'TABLE'
,
4
, 'VIEW'
,
5
, 'SYNONYM'
,
6
, 'SEQUENCE'
,
7
, 'PROCEDURE'
,
8
, 'FUNCTION'
,
9
, 'PACKAGE'
,
11
, 'PACKAGE BODY'
,
12
, 'TRIGGER'
,
--- -3
, 'UPDATABLE SNAPSHOT'
,
'UNDEFINED')
,
DECODE (REASON
,
0
, 'REPLICATION TRIGGER'
,
1
, 'REPLICATION PACKAGE'
,
2
, 'RESOLUTION PACKAGE'
,
3
, 'PRIORITY PACKAGE'
,
4
, 'AUDIT PACKAGE'
,
5
, 'PROCEDURAL REPLICATION WRAPPER'
,
6
, 'TRIGGER PACKAGE'
,
7
, 'MIXED REPLICATION TRIGGER'
,
8
, 'MIXED REPLICATION WRAPPER'
,
9
, 'LOB PACKAGE'
,
10
, 'REPLICATION UPDATE PACKAGE'
,
'UNDEFINED')
,
BASE_SNAME
,
BASE_ONAME
,
DECODE (BASE_TYPE
,
-1
, 'SNAPSHOT'
,
1
, 'INDEX'
,
2
, 'TABLE'
,
4
, 'VIEW'
,
5
, 'SYNONYM'
,
6
, 'SEQUENCE'
,
7
, 'PROCEDURE'
,
8
, 'FUNCTION'
,
9
, 'PACKAGE'
,
11
, 'PACKAGE BODY'
,
12
, 'TRIGGER'
,
--- -3
, 'UPDATABLE SNAPSHOT'
,
'UNDEFINED')
,
PACKAGE_PREFIX
,
PROCEDURE_PREFIX
,
DISTRIBUTED
FROM SYSTEM.REPCAT$_GENERATED
|
|
|