微笑要怎么平静纯白
2016-04-11 12:01
采纳率: 33.3%
浏览 3.8k

用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-2016 2016-04-17 14:56

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

    评论
    解决 无用
    打赏 举报
  • kida_yuan 2016-05-30 07:02

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

    评论
    解决 无用
    打赏 举报
  • wolfler 2016-06-14 09:31

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

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题