Oracle 12C: slight behavioral changes in schema creation in Oracle12C

Creating user in Oracle12C has changed a bit. Session will need to be altered to get old script working.




CREATE USER XX_A PROFILE "DEFAULT" IDENTIFIED BY "oracle" DEFAULT TABLESPACE "XX_DATEN" ACCOUNT UNLOCK
            *
ERROR at line 1:
ORA-65096: invalid common user or role name




SQL> alter session set "_ORACLE_SCRIPT"=true;
Session altered.




SQL> CREATE USER "XX_" PROFILE "DEFAULT" IDENTIFIED BY "oracle" DEFAULT TABLESPACE "XX_DATEN" ACCOUNT UNLOCK;

User created.