ORA-01536:表空间不够解决方法

当创建一个表，或者插入数据时，出现下面问题：

ORA-01536:space quota exceeded for tablespace

SQL> l

1* select username,tablespace_name,bytes,max_bytes from dba_ts_quotas

SQL> /

USERNAME TABLESPACE_NAME BYTES MAX_BYTES

---------- ------------------------------ ---------- ----------

DMSYS SYSAUX 262144 209715200

CEIDB CEI_TS_BASE 3473408 -1

OLAPSYS SYSAUX 16318464 -1

SYSMAN SYSAUX 50397184 -1

SQL> alter user lhomswas quota unlimited on PUB_NORM_SPACE;

User altered.

SQL> select username,tablespace_name,bytes,max_bytes from dba_ts_quotas;