Oracle创建用户报ORA-65096错的解决

问题

Oracle18c 在创建用户时，报如下错误

ERROR at line 1:
ORA-65096: invalid common user or role name

SQL> CREATE USER EDUCLOUD-YN IDENTIFIED BY password
DEFAULT TABLESPACE EDUCLOUD_YN_BASE_DATA
TEMPORARY TABLESPACE TEMP
PROFILE "DEFAULT"
QUOTA UNLIMITED ON EDUCLOUD_YN_BASE_DATA; 
CREATE USER EDUCLOUD-YN IDENTIFIED BY password
*
ERROR at line 1:
ORA-00922: missing or invalid option

解决方法

SQL> alter session set "_ORACLE_SCRIPT"=true;
Session altered.
SQL> commit;
Commit complete.
重新创建
SQL> CREATE USER EDUCLOUD_YN IDENTIFIED BY password
DEFAULT TABLESPACE EDUCLOUD_YN_BASE_DATA
TEMPORARY TABLESPACE TEMP
PROFILE "DEFAULT"
QUOTA UNLIMITED ON EDUCLOUD_YN_BASE_DATA; 
User created.
可以创建成功

原文链接：Oracle创建用户报ORA-65096错的解决，转载请注明来源！