Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Connect /nolog...
Connect to sqlplus but do not logon to any schema as in :
dev817> sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 11 15:38:38 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> show user
USER is ""
SQL> select * from user_tables;
SP2-0640: Not connected
It allows you to get in in a similar manner to the old svrmgrl utility where youinvariably followed this up with a 'conect internal' prior to starting the instance up.
In 9i, svrmgrl is no more, so you need sqlplus to start things off.
HTH
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Jane O [mailto:janeohin_at_aol.com]
Posted At: Wednesday, June 11, 2003 2:57 PM
Posted To: server
Conversation: Connect /nolog...
Subject: Connect /nolog...
When starting up the instance...
What does
Connect /nolog...
mean/do ?
Thanks
Jane
Received on Wed Jun 11 2003 - 09:42:30 CDT