ORA-01950:no privileges on tablespace 'USERS'
来源:互联网 发布:网络分销商城管理系统 编辑:程序博客网 时间:2024/06/05 17:40
ORA-01950:no privileges on tablespace 'USERS'
SQL>create user myuser identitied by password;
SQL>grant create session,resource,connect to myuser;
SQL>conn myuser/password;
SQL>create table TT(id number,name nvarchar2(20));
出错:ORA-01950:no privileges on tablespace 'USERS'
问题:没有分配表空间配额:
SQL>conn sys/password as sysdba;
SQL>alter user myuser quota 10M[unlimited] on users;
OK解决了!
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'错误
- 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 '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
- PHP用strpos函数屏蔽关键字
- wdm驱动dbg输出
- 使用中国气象局的天气预报webservice,wsdl2java生成JAVA类时报错
- vc申请内存结构
- Handler sendMessage 与 obtainMessage (sendToTarget)比较
- ORA-01950:no privileges on tablespace 'USERS'
- cocos2d-x CCScene场景的切换
- PHP中日期加减方法
- Hash Join是Oracle CBO时代经常出现的一种连接方式
- 高仿微信气泡聊天
- SQL使用where子句规定选择的标准
- shell入门基础必备
- jquery ---jQueryEasyUI
- ssky-keygen + ssh-copy-id 无密码登陆远程LINUX主机