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.