How to create user without C## in oracle 12c
How to create user without C## in oracle 12c Even after using hidden parameter in init file, i am unable to create user without c##. But when we setup session level then i am able to create user without c## . Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> sho parameter _oracle NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _oracle_script boolean TRUE SQL> create user anil identified by anil; create user anil identified by anil * ERROR at line 1: ORA-65096: invalid common user or role name After setting hidden parameter at session level .. SQL> alter session set "_oracle_script"=true; Session altered. SQL> sho pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ----------