CREATE USER xx IDENTIFIED BY yy DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE "DEFAULT" QUOTA UNLIMITED ON USERSError at line 2ORA-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 0PL/SQL Release 12.1.0.1.0 - Production 0CORE 12.1.0.1.0 Production 0TNS for 64-bit Windows: Version 12.1.0.1.0 - Production 0NLSRTL Version 12.1.0.1.0 - Production 0
转载于:https://www.cnblogs.com/siyunianhua/p/3646788.html
