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

Popular posts from this blog

ORA-28086: The data redaction policy expression has an error

Useful OEM Queries to get Target details from OEM Repository

ORA-65139: Mismatch between XML metadata file and data file