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.
2. If found, find the owner of that object.
3. Grant unlimited tablespace to that user.
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/