Home » RDBMS Server » Server Administration » space quota exceeded for tablespace (ORACLE10g)
space quota exceeded for tablespace [message #348632] Wed, 17 September 2008 08:00 Go to next message
Messages: 41
Registered: March 2006
Location: india

My application throws the follwoing error

ORA-01536: space quota exceeded for tablespace

The tablespace used by my user is SAAS_DAT. And the user has QUOTA unlimited on SAAS_DAT.

The data file details are as given below.

----------------------------------------------------------------- ---------- ---------- -----------
/u01/app/oracle/product/ I001_DAT 50 500
/u01/app/oracle/product/ SGAP_DAT 50 500
/u01/app/oracle/product/ SAAS_DAT 360 500
/u01/app/oracle/product/ SAAS_DAT 50 500
/u01/app/oracle/product/ SYSAUX 430 32767.9844
/u01/app/oracle/product/ SYSTEM 500 32767.9844
/u01/app/oracle/product/ SYSTEM 50 500
/u01/app/oracle/product/ UNDOTBS1 70 32767.9844
/u01/app/oracle/product/ USERS 5 32767.9844

I find enough free space in the tablespace SAAS_DAT, but still i get the error "space quota exceeded for tablespace"

Any help to solve this is highly appreciated.

Re: space quota exceeded for tablespace [message #348647 is a reply to message #348632] Wed, 17 September 2008 08:38 Go to previous message
Messages: 4768
Registered: February 2005
Location: East Coast USA
Senior Member
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.

Whatever you were doing was trying to create new segments and ran out of space (ie. join, insert, etc.)
Previous Topic: Invalid Objects: SPACE_FREE & SPACE_AVAILABLE
Next Topic: Instance vs Schema
Goto Forum:

Current Time: Tue Aug 22 08:16:26 CDT 2017

Total time taken to generate the page: 0.01515 seconds