ORA-65096: invalid common user or role name

CREATE USER xx IDENTIFIED BY yy
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE "DEFAULT"
QUOTA UNLIMITED ON USERS
Error at line 2
ORA-65096: invalid common user or role name

查阅官网文档得知是Oracle 12c最新的CDB和PDB管理方式造成的

 

如果想创建用户，需使用CDB的创建方式

CREATE USER C##XX IDENTIFIED  BY YY

 

打开Oracle - OraDB12Home1/Application Development/SQL Plus

登录之后

SQL>show con_name;

CON_NAME

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

CDB$ROOT

SQL>SELECT * FROM v$version

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0
PL/SQL Release 12.1.0.1.0 - Production 0
CORE 12.1.0.1.0 Production 0
TNS for 64-bit Windows: Version 12.1.0.1.0 - Production 0
NLSRTL Version 12.1.0.1.0 - Production 0