Spooling from svrmgr30

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 3 Sep 1999 09:24:34 GMT
Message-ID: <01bef5f6$bad0f950$2c289a0a@apollo>

While spooling from svrmgr30 is there a way to set heading off and set feedback off?

I am implementing a automated cold backup on Oracle 8.0.5 on NT 4. When the databaseservices are stopped Orashut.bat is called. It starts svrmgr30 as internal and runs the script Orashut.sql. At this time I want to select from v$datafile the files to backup and spool them to a batfile like this:

set feedback off
set heading off
spool mybat.bat
select 'copy '||NAME||' to dest' from v$datafile; -- v$logfile, v$controlfile
set feedback on
set heading on
spool off

but the feedback and heading get spooled too. I cant use plus80.exe since im connected as internal.

Any other way to do this?

Thanks
Peter Laursen Received on Fri Sep 03 1999 - 04:24:34 CDT