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
gokul_ifs
Messages: 41
Registered: March 2006
Location: india
Member
Hi,

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.

FILE_NAME TABLESPACE DF_SIZE DF_MAX_SIZE
----------------------------------------------------------------- ---------- ---------- -----------
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/II001_DAT.DBF I001_DAT 50 500
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/SGAP_DAT.DBF SGAP_DAT 50 500
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/saas_dat1.dbf SAAS_DAT 360 500
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/saas_dat2.dbf SAAS_DAT 50 500
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/sysaux01.dbf SYSAUX 430 32767.9844
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/system01.dbf SYSTEM 500 32767.9844
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/system02.dbf SYSTEM 50 500
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/undotbs01.dbf UNDOTBS1 70 32767.9844
/u01/app/oracle/product/10.2.0.1/SAASDB/oradata/users01.dbf 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.

Thanks,
GOKUL
Re: space quota exceeded for tablespace [message #348647 is a reply to message #348632] Wed, 17 September 2008 08:38 Go to previous message
joy_division
Messages: 4640
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: Not able to create database
Next Topic: Instance vs Schema
Goto Forum:
  


Current Time: Fri Dec 02 20:32:03 CST 2016

Total time taken to generate the page: 0.08906 seconds