OraFAQ Forum: Client Tools

Home » Other » Client Tools » /nolog

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

/nolog [message #311320]

Fri, 04 April 2008 01:42

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

Report message to a moderator

Re: /nolog [message #311324 is a reply to message #311320]

Fri, 04 April 2008 01:49

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Quote:

what all operations can one perform?

Report message to a moderator

Re: /nolog [message #311327 is a reply to message #311324]

Fri, 04 April 2008 01:56

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.

Report message to a moderator

Re: /nolog [message #311329 is a reply to message #311327]

Fri, 04 April 2008 01:59

pablolee
Messages: 2882
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

Report message to a moderator

Re: /nolog [message #311330 is a reply to message #311329]

Fri, 04 April 2008 02:02

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

Ok.

Just to start sqlplus without logging in, but for what purpose?

Report message to a moderator

Re: /nolog [message #311335 is a reply to message #311330]

Fri, 04 April 2008 02:10

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Google is your friend.
1 Example

Report message to a moderator

Re: /nolog [message #311337 is a reply to message #311335]

Fri, 04 April 2008 02:13

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

ok thank you so much

Report message to a moderator

Previous Topic:	basic SQL+ setting
Next Topic:	Pasword reset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 19:24:12 CDT 2024