Home » SQL & PL/SQL » SQL & PL/SQL » how to handle this error: ORA-00988 ???
how to handle this error: ORA-00988 ??? [message #209078] Wed, 13 December 2006 04:16 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

I execute the sql command as following in data guard primary database. and then execute failure, I search this error in oracle web site, but can not find this. what problem in this?

http://www.oracle.com/pls/db102/search?remark=quick_search&word=ORA-00988&tab_id=&format=ranked


SQL> create user jordan identified by '123456'
2 default tablespace szxgs_ts
3 temporary tablespace temp
4 quota 3m on szxgs_ts
5 password expire;
create user jordan identified by '123456'
*
ERROR at line 1:
ORA-00988: missing or invalid password(s)
Re: how to handle this error: ORA-00988 ??? [message #209081 is a reply to message #209078] Wed, 13 December 2006 04:23 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Umm - the error says missing or invalid password.
Given that the password is not missing, what do you think the problem is likely to be?

From the documentation

1) Passwords shouldn't be enclosed in quotes
2) Passwords follow standard schema object naming rules - ie they need to start with an A-Z

Previous Topic: how to change unused to used columns
Next Topic: Hw to enable entry in USER_AUDIT_SESSION
Goto Forum:
  


Current Time: Sun Dec 04 18:41:19 CST 2016

Total time taken to generate the page: 0.14108 seconds