OraFAQ Forum: Server Administration » space quota exceeded for tablespace

Home » RDBMS Server » Server Administration » space quota exceeded for tablespace (ORACLE10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

space quota exceeded for tablespace [message #348632]

Wed, 17 September 2008 08:00

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

Report message to a moderator

Re: space quota exceeded for tablespace [message #348647 is a reply to message #348632]

Wed, 17 September 2008 08:38

joy_division
Messages: 4963
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.)

Report message to a moderator

Previous Topic:	Not able to create database
Next Topic:	Instance vs Schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 07 23:56:15 CDT 2024