select "OWNER","NAME","SNAPSHOT_SITE","CAN_USE_LOG","UPDATABLE","REFRESH_METHOD","SNAPSHOT_ID","VERSION","QUERY_TXT" from dba_registered_snapshots s
where exists (select snapshot_id from user_snapshot_logs u
where s.snapshot_id = u.snapshot_id)
SELECT "OWNER"
, "NAME"
, "SNAPSHOT_SITE"
, "CAN_USE_LOG"
, "UPDATABLE"
, "REFRESH_METHOD"
, "SNAPSHOT_ID"
, "VERSION"
, "QUERY_TXT"
FROM DBA_REGISTERED_SNAPSHOTS S
WHERE EXISTS (SELECT SNAPSHOT_ID
FROM USER_SNAPSHOT_LOGS U
WHERE S.SNAPSHOT_ID = U.SNAPSHOT_ID)
|
|
|