2 qq 24227893 qq_24227893 于 2016.04.11 20:01 提问

用sql developer创建新用户出现问题。。新手,第一次用oracle,求解

在行 2 上开始执行命令时出错:
CREATE USER ##liupeng IDENTIFIED BY liupeng
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
命令出错, 行: 2 列: 13
错误报告:
SQL 错误: ORA-00911: 无效字符
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.
*Action:

在行 7 上开始执行命令时出错:
GRANT "DBA" TO ##liupeng
错误报告:
SQL 错误: ORA-00911: 无效字符
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.
*Action:

在行 12 上开始执行命令时出错:
ALTER USER ##liupeng QUOTA UNLIMITED ON SYSTEM
错误报告:
SQL 错误: ORA-00911: 无效字符
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.

3个回答

leo__1990
leo__1990   2016.04.17 22:56

很明显报错是因为“USERS”双引号无法标识,正确语法如下:
create user scott identified by tigger
default tablespace USERS
temporary tablespace TEMP;

kida_yuan
kida_yuan   2016.05.30 15:02

其实我想说,你可以通过PLSQL自己去界面创建后在view sql看看人家标准的写法是怎样的

wolfler
wolfler   2016.06.14 17:31

用户名不合法
一般就用字母 下划线 数字组合就好
注意用字母做开头

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!