ORA-01536 空间足够

Oracle Server - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 27-Jun-2012***

SYMPTOMS

Insert on a table reports: ORA-01536.

01536, 00000, "space quota exceeded for tablespace '%s'"
// *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.


Enough space is available in the tablespace.
A 'grant unlimited tablespace to has been executed.
However, the same error remains.

CAUSE

There may be a dependency object on this table.
Insert on this object may need to update the dependant object, which really exhausted the quota.
However, the error will be reported generally.

SOLUTION

1. Find any dependant objects for that table.

SQL> select NAME,TYPE from dba_dependencies where REFERENCED_NAME='table name';

2. If found, find the owner of that object.

SQL> select OWNER,OBJECT_NAME from dba_objects where OBJECT_NAME='dependant object name';

3. Grant unlimited tablespace to that user.

SQL> grant unlimited tablespace to ;

4. Now you will be able to do the insertion on that table.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15747463/viewspace-1162946/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15747463/viewspace-1162946/