错误:ORA-65096:Oracle中无效的普通用户或角色名称 [英] error: ORA-65096: invalid common user or role name in oracle

问题描述

我刚刚安装了oracle11g，但缺少了Scott模式.所以我想自己生成它.我得到了"Scott"模式的SQL脚本，但是当我尝试运行查询创建由老虎标识的用户Scott"时，它显示以下错误:

I just installed oracle11g, and it was missing the Scott schema. So i am trying to generate it myself. I got the sql script of "Scott" schema, but when i try to run the query "create user Scott identified by tiger;" it displays the following error:

ORA-65096:在oracle中无效的通用用户名或角色名.

ORA-65096: invalid common user or role name in oracle.

基本上，不允许我创建用户"Scott".为什么会这样，我该如何解决我的问题?

Basically it is not allowing me to create a user "Scott". Why is that, and how can I fix my problem?

推荐答案

在创建用户之前运行:

alter session set "_ORACLE_SCRIPT"=true;  

我在这里找到了答案

请注意，仅在Oracle支持的指导下设置像这样的未记录参数(如前划线所示).在没有此类指导的情况下更改此类参数可能会使您的支持合同无效.这样做的后果自负.

Please be aware that setting undocumented parameters like this (as indicated by the leading underscore) should only be done under the direction of Oracle Support. Changing such parameters without such guidance may invalidate your support contract. So do this at your own risk.

这篇关于错误:ORA-65096:Oracle中无效的普通用户或角色名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！