Home » SQL & PL/SQL » Client Tools » /nolog
/nolog [message #311320] Fri, 04 April 2008 01:42 Go to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi

when we use sqlplus /nolog what all operations can one perform?

What is the significance of this kind of login
Re: /nolog [message #311324 is a reply to message #311320] Fri, 04 April 2008 01:49 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member

Quote:
what all operations can one perform?
Login.

Nolog allows you to start up sqlplus without actually logging in (no log)
Re: /nolog [message #311327 is a reply to message #311324] Fri, 04 April 2008 01:56 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
So it is used only for logging on ?


C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Apr 4 12:24:03 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> select * from tab;
SP2-0640: Not connected
SQL> sho user
USER is ""
SQL>


What can we do by logging in as /nolog ? i was executing a script that connects to the database of another user and generates an html report.
Re: /nolog [message #311329 is a reply to message #311327] Fri, 04 April 2008 01:59 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:
So it is used only for logging on ?

No, that's not what I said. Read my post again
Re: /nolog [message #311330 is a reply to message #311329] Fri, 04 April 2008 02:02 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Ok.

Just to start sqlplus without logging in, but for what purpose?
Re: /nolog [message #311335 is a reply to message #311330] Fri, 04 April 2008 02:10 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Google is your friend.
1 Example
Re: /nolog [message #311337 is a reply to message #311335] Fri, 04 April 2008 02:13 Go to previous message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
ok thank you so much
Previous Topic: basic SQL+ setting
Next Topic: Pasword reset
Goto Forum:
  


Current Time: Tue Dec 06 12:30:15 CST 2016

Total time taken to generate the page: 0.15374 seconds