SELECT owner, ownerid, name, table_name, master_view, master_link,
mtime, can_use_log, error, type, query, MOD(flag, 65536),
rowid_snap, primkey_snap, update_snap, update_trig, update_log,
mastabs, masver, lob_vector, snapshot, snapid, 2
FROM sys.exu81snap
WHERE BITAND(flag, 28672) = 0 AND /* Do not include MAVs or MJVs */
instsite = 0 AND /* Do not include RepAPI snapshots */
table_name LIKE 'SNAP$_%'
SELECT OWNER
, OWNERID
, NAME
, TABLE_NAME
, MASTER_VIEW
, MASTER_LINK
,
MTIME
, CAN_USE_LOG
, ERROR
, TYPE
, QUERY
, MOD(FLAG
, 65536)
,
ROWID_SNAP
, PRIMKEY_SNAP
, UPDATE_SNAP
, UPDATE_TRIG
, UPDATE_LOG
,
MASTABS
, MASVER
, LOB_VECTOR
, SNAPSHOT
, SNAPID
, 2
FROM SYS.EXU81SNAP
WHERE BITAND(FLAG
, 28672) = 0
AND /* DO NOT INCLUDE MAVS OR MJVS */
INSTSITE = 0
AND /* DO NOT INCLUDE REPAPI SNAPSHOTS */
TABLE_NAME LIKE 'SNAP$_%'
|
|
|