SELECT log_owner, log_ownerid, master, log_table, log_trigger,
/* Clear bit (0x0040) indicating a temporary log was created */
DECODE(BITAND(flag, 64), 64, flag - 64, flag), youngest,
oldest, oldest_pk, mtime, rowid_snapl, primkey_snapl, 2
FROM sys.exu81snapl
SELECT LOG_OWNER
, LOG_OWNERID
, MASTER
, LOG_TABLE
, LOG_TRIGGER
,
/* CLEAR BIT (0X0040) INDICATING A TEMPORARY LOG WAS CREATED */
DECODE(BITAND(FLAG
, 64)
, 64
, FLAG - 64
, FLAG)
, YOUNGEST
,
OLDEST
, OLDEST_PK
, MTIME
, ROWID_SNAPL
, PRIMKEY_SNAPL
, 2
FROM SYS.EXU81SNAPL
|
|
|