Home > SQL > show snapshot dependency between master and slave

show snapshot dependency between master and slave

–qmlogs.sql
–RUN AT MASTER SITE
COL LOG_OWNER FORMAT A8
COL OWNER FORMAT A10
COL MASTER FORMAT A25
COL NAME FORMAT A32
COL LOG_TABLE FORMAT A30
COL SNAPSHOT_SITE FORMAT A24
SELECT UNIQUE
*
FROM
((SELECT
OWNER
,NAME
,SNAPSHOT_SITE
,CAN_USE_LOG
,REFRESH_METHOD
, LOG_OWNER
,LOG_TABLE
,ROWIDS
,PRIMARY_KEY
,CURRENT_SNAPSHOTS
,A.SNAPSHOT_ID SID
FROM user_snapshot_logs A
, user_REGISTERED_SNAPSHOTS B
WHERE B.SNAPSHOT_ID = A.SNAPSHOT_ID(+)
)
UNION
(SELECT
OWNER
,NAME
,SNAPSHOT_SITE
,CAN_USE_LOG
,REFRESH_METHOD
, LOG_OWNER
,LOG_TABLE
,ROWIDS
,PRIMARY_KEY
,CURRENT_SNAPSHOTS
,A.SNAPSHOT_ID SID
FROM user_snapshot_logs A
, user_REGISTERED_SNAPSHOTS B
WHERE A.SNAPSHOT_ID = B.SNAPSHOT_ID(+))
ORDER BY 1,2,3)
/

Advertisements
Categories: SQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: