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
Messages: 92
Registered: December 2006

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?


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
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: Thu Aug 17 14:26:09 CDT 2017

Total time taken to generate the page: 0.21325 seconds