Oracle SQL Plus: Error “ORA-00922: missing or invalid option” when creating user
18,026
According to the oracle DOCS:
Nonquoted identifiers must begin with an alphabetic character from your database character set. Quoted identifiers can begin with any character.
so its good practice to use quotes around the password!
ref: https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements008.htm
Author by
fLen
Updated on June 15, 2022Comments
-
fLen almost 2 years
This is my first time to use SQLPlus and Oracle. (exploring other DBMS) :)
Using SQL Plus, I'm trying to create user.
SQL> create user <username> identified by <password>;
But it shows error:
ORA-00922: missing or invalid option
What do I missed?
:(
-
fLen about 8 yearsThanks! user created. :D