oracle 12C 不同于 其他版本创建用户:
创建用户 :
SQL> create user c##Rain identified by liurain ;
用户已创建。
SQL> CREATE USER "Rain" IDENTIFIED BY "liurain" ACCOUNT UNLOCK PROFILE "DEFAULT";
CREATE USER "Rain" IDENTIFIED BY "liurain" ACCOUNT UNLOCK PROFILE "DEFAULT"
*
第 1 行出现错误:
ORA-65096: 公用用户名或角色名无效
SQL> create user shopping identified by 123456;
create?user?shopping?identified?by?123456
*
第 1 行出现错误:
ORA-00911: 无效字符
前面需要加c## 才能创建成功