[Home] [Help]
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')
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')
|
|
|
|