599   Oracle RedHat

space quota exceeded for tablespace(表空间不足):解决之道

 

方法一(测试成功):

SQL> conn /as sysdba
Connected.

 

SQL> alter user “用户”quota unlimited on “表空间名”;

User altered.
方法二:SQL> alter user “用户” default tablespace “表空间名”;

2  quota 0 on system
3  quota 500M on testtablespace
4  /

User altered.

方法三:SQL> GRANT UNLIMITED TABLESPACE TO test;

Grant succeeded.




Leave a Reply

Your email address will not be published. Required fields are marked *