For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
hi in oracle database 18c when i create user with password ! am geting errro ORA-00922: missing or invalid option create user test1 identified by password08!
but when i did this is ok create user test1 identified by password08
SQL> create user test1 identified by password08! 2 / create user test1 identified by password08! * ERROR at line 1: ORA-00922: missing or invalid option SQL> create user test1 identified by "password08!" 2 / User created. SQL> grant create session to test1 2 / Grant succeeded. SQL> connect test1@pdb1sol122/password08! Connected. SQL>
SY.
Did you think to check the documentation? This is a one-minute exercise. You would find easily what is and what is not allowed in a password. I can post a link to the documentation, but then you won't learn anything from it; I will let you find the documentation and answer your own question. Good luck!