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.