ORA-01536 space quota exceeded for tablespace ' string '
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01536 from Oracle 10g ?
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.
How to deal with ORA-01536 from Oracle 10g ?
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.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01528 EOF while processing SQL statement
- ORA-01529 error closing file ' string '
- ORA-01530 a database already mounted by the instance
- ORA-01531 a database already open by the instance
- ORA-01532 cannot create database; instance being started elsewhere
- ORA-01533 cannot rename file ' string '; file does not belong to tablespace
- ORA-01534 rollback segment ' string ' doesn't exist
- ORA-01535 rollback segment ' string ' already exists
- ORA-01537 cannot add data file ' string ' - file already part of database
- ORA-01538 failed to acquire any rollback segment
- ORA-01539 tablespace ' string ' is not online
- ORA-01540 tablespace ' string ' is not offline
- ORA-01541 system tablespace cannot be brought offline; shut down if necessary
- ORA-01542 tablespace ' string ' is offline, cannot allocate space in it
- ORA-01543 tablespace ' string ' already exists
- ORA-01544 cannot drop system rollback segment