ORA-01950: no privileges on tablespace 'USERS'错误
来源:互联网 发布:ae cc2015软件破解视频 编辑:程序博客网 时间:2024/06/07 06:13
sys用户
SQL> create user etl identified by *****;
User created.
SQL> grant create session to etl;
Grant succeeded.
SQL> grant sysdba to etl;
Grant succeeded.
SQL> grant create any table to etl;
Grant succeeded.
etl用户:
SQL> create table test(A varchar2(100));
create table test(A varchar2(100))
ORA-01950: no privileges on tablespace 'USERS'
etl用户在users表空间没有权限,需要给etl用户在users表空间分配配额。
sys用户:
GRANT UNLIMITED TABLESPACE TO etl;
或者:
alter user youruser quota 100m on users;
etl用户:
SQL> create table test(A varchar2(100));
Table created
0 0
- 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 '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 '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
- ORA-01950: no privileges on tablespace
- POJ1655Balancing Act(树形DP)
- 一个男人关心的东西 决定了他的层次
- Unit tests
- iOS开发从新手到app store上架
- NGUI学习笔记(四)UIPanel
- ORA-01950: no privileges on tablespace 'USERS'错误
- Test-Driven Development and Testing Early
- hdu 1532&&poj1273 基础最大流
- poj 2528 Mayor's posters
- python中的常用模块
- 超线程(Hyper-Threading)
- 深入浅出K-Means算法
- cframewnd oncreatecontrol
- 360通用防护 过滤用户输入的数据 实现防注