oracle 通用用户名或角色名无效
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/22886791/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Invalid common user or role name
提问by Nisar
why is this showing error..
为什么这个显示错误..
SQL> create user nisar identified by kk ;
create user nisar identified by kk
*
ERROR at line 1:
ORA-65096: invalid common user or role name
第 1 行的错误：
ORA-65096: 无效的通用用户名或角色名
采纳答案by Alex Poole
You're trying to create a common user, not a container user, with an invalid name:
您正在尝试使用无效名称创建普通用户，而不是容器用户：
ORA-65096: invalid common user or role name
Cause: An attempt was made to create a common user or role with a name that wass not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters.
Action: Specify a valid common user or role name.
ORA-65096：无效的通用用户或角色名称
原因：尝试创建一个通用用户或角色，其名称对通用用户或角色无效。除了用户名和角色名的通常规则外，常见的用户名和角色名必须以 C## 或 c## 开头，并且只能由 ASCII 字符组成。
行动：指定一个有效的公共用户或角色名称。
If you want to create a user in a particular container then you can use the alter session set containerfirst, so your createis applied within that container. If you really do want a common user, follow the naming rules above.
如果您想在特定容器中创建用户，那么您可以使用第alter session set container一个，以便create在该容器中应用您。如果您确实想要一个普通用户，请遵循上面的命名规则。
回答by Shane chen
I had used below command. It's very useful. So, I would like to recommend to you.
我使用了以下命令。这是非常有用的。所以，我想推荐给你。
alter session set "_ORACLE_SCRIPT"=true;
For more information, see: http://www.dba-oracle.com/t_ora_65096_create_user_12c_without_c_prefix.htm
有关更多信息，请参阅：http: //www.dba-oracle.com/t_ora_65096_create_user_12c_without_c_prefix.htm
