DBA Data[Home] [Help]

VIEW: SYS.USER_SNAPSHOT_LOGS

Source

View Text - Preformatted

select log_owner, master, log_table, log_trigger, rowids, primary_key,
       object_id, filter_columns, sequence, include_new_values,
       current_snapshots, snapshot_id
from dba_snapshot_logs s, sys.user$ u
where s.log_owner = u.name
  and u.user# = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT LOG_OWNER
, MASTER
, LOG_TABLE
, LOG_TRIGGER
, ROWIDS
, PRIMARY_KEY
, OBJECT_ID
, FILTER_COLUMNS
, SEQUENCE
, INCLUDE_NEW_VALUES
, CURRENT_SNAPSHOTS
, SNAPSHOT_ID FROM DBA_SNAPSHOT_LOGS S
, SYS.USER$ U WHERE S.LOG_OWNER = U.NAME
AND U.USER# = USERENV('SCHEMAID')