Re: backup script
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: ineyman@xxxxxxxxxxxxxx
- Date: Wed, 30 Mar 2005 20:01:03 +0100
On Wed, 30 Mar 2005 13:37:08 -0500, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote:
> Why reading the registry?
> You could just use %ORACLE_HOME% system variable in your script.
I think you are thinking of a sqlplus script, the chances are that
this environment variable isn't available directly from a command
prompt.
***** proof that the envvar isn't set
C:\TEMP>SET O
OS=Windows_NT
OSVER=winXPP
C:\TEMP>SET ORA
Environment variable ORA not defined
***** but available in sqlplus.
C:\TEMP>SQLPLUS /
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Mar 30 19:54:21 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @%ORACLE_HOME%\RDBMS\ADMIN\DEMO
User created.
Grant succeeded.
Grant succeeded.
User altered.
User altered.
Connected.
etc etc
Me, I'd go with the sqlplus version. I don't see why the ORACLE_HOME
directory is required in an NT backup script anyway.
actually I'd also go with vbscript and not dos scripting (unless
Jared is watching - in which case of course there is no alternative to
perl :) )
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
