ORA-01950: no privileges on tablespace 'USERS'--解决办法
来源:互联网 发布:河南民生频道网络直播 编辑:程序博客网 时间:2024/06/07 05:42
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'
原因:在表空间“USERS”无权限
解决办法:
用户登录,查看当前用户所属表空间:
select
username,default_tablespace
from
dba_users;
修改表空间:alter user username quota umlimited on tablespacename;
或者 grant resource to username 也可以
因为 grant resource to username 时 自动获得了有unlimited tablespace的系统权限
0 0
- ORA-01950: no privileges on tablespace 'USERS'--解决办法
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950: no privileges on tablespace 'USERS'
- ORA-01950: no privileges on tablespace 'USERS'错误
- ORA-01950: no privileges on tablespace 'USERS'错误
- ORA-01950: no privileges on tablespace 'USERS'错误
- Oracle错误:ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950: no privileges on tablespace 'USERS'错误
- [转]ORA-01950: no privileges on tablespace 解决办法
- ORA-01950: no privileges on tablespace 'xxxxxx'
- ORA-01950: no privileges on tablespace
- ORA-01950: no privileges on tablespace 'SNOOPY'
- ORA-01950: no privileges on tablespace
- ORA-01950: no privileges on tablespace
- Rsync文件同步
- lightoj 1259
- 设计模式之工厂模式
- 今日头条血槽已空
- Hdu 3966 . Aragorn's Story
- ORA-01950: no privileges on tablespace 'USERS'--解决办法
- 字母变成下一字母
- Java集合(三):Queue队列
- 腾讯云上PhantomJS用法示例
- AngularJS入门
- Unity3D手游开发日记(11)
- Gale-Shapley---婚姻匹配算法算法
- D
- NS3编译错误cc1plus: all warnings being treated as errors解决方法