ORA-01536:表空間不夠 解決方法

 

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;

 

USERNAME   TABLESPACE_NAME                     BYTES  MAX_BYTES

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

DMSYS      SYSAUX                             262144  209715200

CEIDB      CEI_TS_BASE                       3473408         -1

LHOMSWAS   PUB_NORM_SPACE                  972554240         -1

OLAPSYS    SYSAUX                           16318464         -1

SYSMAN     SYSAUX                           50397184         -1