38 lines
1003 B
SQL
38 lines
1003 B
SQL
@@myheader.sql
|
|
|
|
/************************************
|
|
* INPUT PARAMETERS
|
|
************************************/
|
|
DEFINE owner="&&1"
|
|
DEFINE table="&&2"
|
|
|
|
|
|
PROMPT
|
|
PROMPT *************************************************
|
|
PROMPT * Registerd napshots on MASTER site
|
|
PROMPT *
|
|
PROMPT * Input Parameters
|
|
PROMPT * - owner = '&&owner'
|
|
PROMPT * - table = '&&table'
|
|
PROMPT *************************************************
|
|
|
|
|
|
set lines 256
|
|
|
|
col mowner for a15
|
|
col master for a25
|
|
|
|
col snapname for a30
|
|
col snapsite for a30
|
|
col snaptime for a30
|
|
|
|
select
|
|
r.name snapname, snapid, nvl(r.snapshot_site, 'not registered') snapsite, snaptime
|
|
from
|
|
sys.slog$ s, dba_registered_snapshots r
|
|
where
|
|
s.snapid=r.snapshot_id(+) and mowner like '&&owner' and master like '&&table';
|
|
|
|
|
|
@@myfooter.sql
|