Home » Other » Client Tools » Changing a db password using the SQLplus command line (11g, Windows XP)
Changing a db password using the SQLplus command line [message #466904] Wed, 21 July 2010 11:56 Go to next message
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.
Re: Changing a db password using the SQLplus command line [message #466909 is a reply to message #466904] Wed, 21 July 2010 12:00 Go to previous messageGo to next message
ramoradba
Messages: 2456
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
Re: Changing a db password using the SQLplus command line [message #466918 is a reply to message #466904] Wed, 21 July 2010 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*PlusĀ® User's Guide and Reference

Regards
Michel
Re: Changing a db password using the SQLplus command line [message #466920 is a reply to message #466918] Wed, 21 July 2010 12:18 Go to previous messageGo to next message
Jeff905
Messages: 2
Registered: July 2010
Junior Member
AWESOME! It worked! Thank you both!
Re: Changing a db password using the SQLplus command line [message #467197 is a reply to message #466920] Thu, 22 July 2010 10:54 Go to previous message
ramoradba
Messages: 2456
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
Previous Topic: Run the Oracle sql script from shared mapped drive
Next Topic: XML DOM Mismatch
Goto Forum:
  


Current Time: Thu Mar 28 08:33:04 CDT 2024