ORA-01536 space quota exceeded for tablespace 'string' Cause The space quota for the segment owner in the tablespace has been exhausted and the operation attempted the creation of a new segment extent in the tablespace. Action Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner.
看看在一个space中的其它表是不是也这样的问题。 如果是的话,请检查磁盘的容量和数据文件的大小。
先看看磁盘空间,再看看user,index等几个表空间的设置。
假如这个表属于用户user1,那么以system用户登录: ALTER USER user1 QUOTA UNLIMITED ON 表空间名;
Action Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner.
如果是的话,请检查磁盘的容量和数据文件的大小。
ALTER USER user1 QUOTA UNLIMITED ON 表空间名;