Re: backup script

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 30 Mar 2005 20:01:03 +0100
Message-ID: <7765c89705033011017d0092b3@mail.gmail.com>

On Wed, 30 Mar 2005 13:37:08 -0500, Igor Neyman <ineyman_at_perceptron.com> 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

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.

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
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 30 2005 - 14:04:46 CST