select sowner, snapname, snapsite,
decode(bitand(flag,1), 0 , 'NO', 'YES'),
decode(bitand(flag,2), 0 , 'NO', 'YES'),
decode(bitand(flag, 32), 32, 'PRIMARY KEY',
decode(bitand(flag, 536870912), 536870912, 'OBJECT ID', 'ROWID')),
snapshot_id,
decode(rep_type, 1, 'ORACLE 7 SNAPSHOT',
2, 'ORACLE 8 SNAPSHOT',
3, 'REPAPI SNAPSHOT',
'UNKNOWN'),
query_txt
from sys.reg_snap$
SELECT SOWNER
, SNAPNAME
, SNAPSITE
,
DECODE(BITAND(FLAG
, 1)
, 0
, 'NO'
, 'YES')
,
DECODE(BITAND(FLAG
, 2)
, 0
, 'NO'
, 'YES')
,
DECODE(BITAND(FLAG
, 32)
, 32
, 'PRIMARY KEY'
,
DECODE(BITAND(FLAG
, 536870912)
, 536870912
, 'OBJECT ID'
, 'ROWID'))
,
SNAPSHOT_ID
,
DECODE(REP_TYPE
, 1
, 'ORACLE 7 SNAPSHOT'
,
2
, 'ORACLE 8 SNAPSHOT'
,
3
, 'REPAPI SNAPSHOT'
,
'UNKNOWN')
,
QUERY_TXT
FROM SYS.REG_SNAP$
|
|
|