错误号ORA-01536:space quota exceeded for table space 'ALCATEL'的解决办法
三个解决办法,任你选择:
(1) alter user USERNAME quota 100M on TABLESPACENAME;
(2) alter user USERNAME quota unlimited on TABLESPACENAME;
(3) grant unlimited tablespace to USERNAME;
(1) alter user USERNAME quota 100M on TABLESPACENAME;
(2) alter user USERNAME quota unlimited on TABLESPACENAME;
(3) grant unlimited tablespace to USERNAME;
先查询一下是否是有控制的,用这个语句
select * from dba_ts_quotas
如果这个max_blocks字段的值不是 -1 那么表明是有限制的
我的用的解决方法是执行:
alter user USERNAME quota unlimited on TABLESPACENAME;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7724693/viewspace-980496/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7724693/viewspace-980496/