OraFAQ Forum: Client Tools » Changing a db password using the SQLplus command line

Home » Other » Client Tools » Changing a db password using the SQLplus command line (11g, Windows XP)

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

Changing a db password using the SQLplus command line [message #466904]

Wed, 21 July 2010 11:56

Jeff905
Messages: 2
Registered: July 2010

Junior Member

Razz

I'm a newbie and I'm trying to change a password. I can connect to the db then at the SQL prompt I'm using:

alter user <name> identified by <new password>

The dos window comes back with '2' - then just sits there

I'm not sure what to do next

Can someone help? Thanks.

Report message to a moderator

Re: Changing a db password using the SQLplus command line [message #466909 is a reply to message #466904]

Wed, 21 July 2010 12:00

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

I'm not sure what to do next

Just end the statement using ';' or '/'

sriram

Report message to a moderator

Re: Changing a db password using the SQLplus command line [message #466918 is a reply to message #466904]

Wed, 21 July 2010 12:16

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL*Plus® User's Guide and Reference

Regards
Michel

Report message to a moderator

Re: Changing a db password using the SQLplus command line [message #466920 is a reply to message #466918]

Wed, 21 July 2010 12:18

Jeff905
Messages: 2
Registered: July 2010

Junior Member

AWESOME! It worked! Thank you both!

Report message to a moderator

Re: Changing a db password using the SQLplus command line [message #467197 is a reply to message #466920]

Thu, 22 July 2010 10:54

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

And you can read the documents at http://tahiti.oracle.com/ which may help you further

Report message to a moderator

Previous Topic:	Run the Oracle sql script from shared mapped drive
Next Topic:	XML DOM Mismatch

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 21:48:15 CST 2025