oracle用户对表空间没权限,ORA-01950:对表空间'XXX'无权限
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.4.0SYMPTOMS:打算将user2表中的数据导入到用户user1的表中去。执行的操作:1.登录system用户2.执行sqlinsert into user1.cux_table_aaa select * from user2.cux_table_aaa3.报错.
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.4.0
SYMPTOMS:
打算将user2表中的数据导入到用户user1的表中去。
执行的操作:
1.登录system用户
2.执行sql
insert into user1.cux_table_aaa select * from user2.cux_table_aaa
3.报错:“ORA-01950:对表空间'XXX'无权限”
CAUSE:
user1 does not have enough quota on the tablespace where the user2.cux_table_aaa table was created.
user1没有user2.cux_table_aaa表所在的表空间的限额。
SOLUTION:
1.查询user2的表空间为XXX
select username, default_tablespace from dba_users where username = 'USER2';
2.赋予用户user1对某个表空间XXX的访问权限
ALTER USER USER1 QUOTA UNLIMITED ON XXX;
外延1:ALTER USER 用户名 QUOTA 1K ON 表空间;
外延2:如何查询Oracle数据库的版本号
system用户执行:select * from v$version;
外延3:如何查询Oracle数据库用户对应默认表空间和临时表空间
system用户执行:
select username, default_tablespace, temporary_tablespace
from dba_users
where username = 'APPS';
更多推荐
所有评论(0)