ORA-00922: missing or invalid option during create user or Change password

Problem:

SQL> create user emunna identified by 1asdas;

create user emunna identified by 1asdas                                  *

ERROR at line 1:

ORA-00922: missing or invalid option

Or

SQL> create user emunna identified by exd@Udhs;

create user emunna identified by exd@Udhs                                    *

ERROR at line 1:

ORA-00922: missing or invalid option

 

Solution:

If you are using special character or start with number without double quotes then you will get ORA-00922 error. Please try with double quotes for the password starting with number or having special characters

 SQL> create user emunna identified by "1asdas";

User created.

 SQL> create user emunna identified by "exd@Udhs";

User created.

Comments