首页 > 解决方案 > 创建在不同表空间中成功创建的表的问题

问题描述

我尝试了以下操作,但收到ORA-01950错误消息

ALTER USER USER1 QUOTA 200M ON NUSERS;
User altered.

GRANT SELECT ON HR.EMPLOYEES TO USER1;
Grant succeeded.

CONN USER1/USER;
Connected.

CREATE TABLE T3 AS SELECT * FROM HR.EMPLOYEES NUSERS;
CREATE TABLE T3 AS SELECT * FROM HR.EMPLOYEES NUSERS
                                *

ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'

标签: oracle12c

解决方案


你说的是:ALTER USER USER1 QUOTA 200M ON NUERS ;

Oracle 响应:ORA-01950:对表空间 ' USERS '没有权限

看到大粗体N的区别了吗?


推荐阅读