try this .....
set heading off verify off feedback off ;
set arraysize 1 long 1000000 termout off ;
spool docsnap.sql
select 'create snapshot '||owner||'.'||name||' as ',query,';'
from dba_snapshots where owner = upper('&&1');
spool off;
Thanks,
Madhu




Reply With Quote