Rodd
On Tue, 2002-10-29 at 09:49, Toepke, Kevin M wrote:
It doesn't?
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 29 10:39:53 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SYS@hydra@fins SQL>
-----Original Message-----
From: Rodd Holman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 29, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: sqlplus /nolog
It opens up a sqlplus session session/shell on the server without logging into a database. The 9i version of sqlplus does not allow for a command line: sqlplus / as sysdba command. You have to login to sqlplus and when prompted for the username then add / as sysdba. The /nolog allows you to script running sqlplus and then having the connect / as sysdba as the first line in your sqlscript ie: sqlplus /nolog @myscript.sql
myscript.sql:
connect / as sysdba
select name from v$database;
....
Rodd
On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote:Hi!
I was wondering what
sqlplus /nolog
actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
-- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED]
-- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] |