DBA Data[Home] [Help]

VIEW: SYS.EXU8SNAPL

Source

View Text - Preformatted

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
View Text - HTML Formatted

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