Re: sys as sysdba within a script?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 21 Dec 2004 08:17:37 +1100
Message-ID: <41c74172$0$5112$afc38c87@news.optusnet.com.au>

Dave wrote:
> Here's the format you must use for the exp command.
>
> exp "'/ as sysdba'"
>
> Note the use of double quote (") and single quote (').
> To use sqlplus you drop the single quotes:
>
> sqlplus "/ as sysdba"
>
> Dave

Another approach is to "escape" the quotes:

exp \"/ as sysdba\"

...which I believe is the solution mentioned in the Oracle documentation (it's definitely the one the Oracle training material uses, anyway).

It's good to have a choice of solutions, anyway, because the "escape" one causes grief on Windows but not on Linux (or the other way around, I can never remember!). Maybe your solution works for all platforms (I'd check if only I wasn't rebuilding the relevant machines...)

Regards
HJR Received on Mon Dec 20 2004 - 15:17:37 CST