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
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TESTPDB1 MOUNTED
SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> create user anil identified by anil;
User created.
We can open PDB$SEED Database as well by setting "_oracle_script"=true.
SQL> alter pluggable database PDB$SEED close;
Pluggable database altered.
SQL> alter pluggable database PDB$SEED open read write;
Pluggable database altered.
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ WRITE NO
3 TESTPDB1 MOUNTED
Comments
Post a Comment