SOLVED

ORA-65096: Invalid Common User Or Role Name

Asked by OracleDba••12 views•oracle
1
2
3
4
5
ORA-65096: Invalid Common User Or Role Name

Problem :

While creating a user in root container multitenant database, got this error.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
We can’t create normal users in root containers. We can create only common users which start with c## in root container.

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

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

User created.
OracleDba•

Post Your Solution