Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: SCR: Hot DB backup script
set serverout on size 1000000
declare
begin
FOR tspace IN (select tablespace_name
from dba_tablespaces )LOOP dbms_output.put_line('ALTER TABLESPACE '||tspace.tablespace_name||
' BEGIN BACKUP;');
FOR dbfile IN (select file_name from dba_data_files
where tablespace_name = tspace.tablespace_name)LOOP
END LOOP; dbms_output.put_line('ALTER TABLESPACE '||tspace.tablespace_name||
' END BACKUP;');
END LOOP;
END;
/
Hope that helps!
Jason. Received on Mon Oct 11 1999 - 08:36:52 CDT