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. |