Hello to all,

I want to start a sqlplus-script for multiple db instances at one time
generating a logfile.
Specified within the sqlplus-script something like this "DEFINE
spoollog=C:\_<Instance_name><SID>"
whereas <Instance_name> and <SID> should be filled up with the appropriate
values.
But I don't know how to transmit this one.
Thank you for all your help.

Best Regards
Johannes

"Johannes" <johannes@merckle.de> wrote in message
news:2sfspgF1kuabiU1@uni-berlin.de...
| Hello to all,
|
| I want to start a sqlplus-script for multiple db instances at one time
| generating a logfile.
| Specified within the sqlplus-script something like this "DEFINE
| spoollog=C:\_<Instance_name><SID>"
| whereas <Instance_name> and <SID> should be filled up with the appropriate
| values.
| But I don't know how to transmit this one.
| Thank you for all your help.
|
| Best Regards
| Johannes
|
|

you probably need to look into the NEW_VALUE option in the SQL*PLus manual
(should be chapter 4, Formatting Query Results)

++ mcs

http://www.oracle.com/technology/sup...lus/index.html

Regards
/Rauf

"Johannes" <johannes@merckle.de> wrote in message news:<2sfspgF1kuabiU1@uni-berlin.de>...
> Hello to all,
>
> I want to start a sqlplus-script for multiple db instances at one time
> generating a logfile.
> Specified within the sqlplus-script something like this "DEFINE
> spoollog=C:\_<Instance_name><SID>"
> whereas <Instance_name> and <SID> should be filled up with the appropriate
> values.
> But I don't know how to transmit this one.
> Thank you for all your help.
>
> Best Regards
> Johannes