ORA-65096: invalid common user or role name

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> create user test identified by test;
create user test identified by test
 *
ERROR at line 1:
ORA-65096: invalid common user or role name

SQL> select PDB from v$services;

PDB
------------------------------
PDB2
PDB1
CDB$ROOT
CDB$ROOT
CDB$ROOT
CDB$ROOT

6 rows selected.

Řešení

COMMON uživatelel musí začínat c##

SQL> create user c##test identified by test;

User created.

Komentáře