Re: Spooling from svrmgr30

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Fri, 03 Sep 1999 12:44:28 +0200
Message-ID: <37CFA68C.E2DD68A3@si.unirioja.es>

Peter Laursen escribió:
> =

> 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 th=
is:
> =

> 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.

Well you can connect as sys from sqlplus ;-)

Regards.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Fri Sep 03 1999 - 05:44:28 CDT