Home » RDBMS Server » Server Administration » ORA-01536: space quota exceeded for tablespace
ORA-01536: space quota exceeded for tablespace [message #239786] Wed, 23 May 2007 05:20 Go to next message
pradeep.ramana
Messages: 12
Registered: March 2007
Junior Member
Hi All,

We are facing the below problem in live application

ORA-01536: space quota exceeded for tablespace 'OTH_TRN_1'.
This problem is coming for other tablespace like 'PART_DATA_3'. But in all these tablespaces enough space is present now also.
Also rollback segment and temporary tablespace is almost 99% full.

Please Can anyone help us?

Thanks in advance.
Re: ORA-01536: space quota exceeded for tablespace [message #239789 is a reply to message #239786] Wed, 23 May 2007 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The problem is not tablespace space but user quota that is the maximum a user can use in a tablespace.

Regards
Michel
Re: ORA-01536: space quota exceeded for tablespace [message #239793 is a reply to message #239789] Wed, 23 May 2007 05:45 Go to previous messageGo to next message
pradeep.ramana
Messages: 12
Registered: March 2007
Junior Member
Hi,

Thanks for the quick reply

We are getting that error on two table spaces default tablespace and and one more table space do we need to allocate user quota on both tablespaces seperately or is it enough if we allocate user quota only on default tablespace?
Re: ORA-01536: space quota exceeded for tablespace [message #239805 is a reply to message #239793] Wed, 23 May 2007 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You need to increase the quota on each tablespace for each user you got the error.

Regards
Michel
Re: ORA-01536: space quota exceeded for tablespace [message #239832 is a reply to message #239805] Wed, 23 May 2007 07:00 Go to previous message
pradeep.ramana
Messages: 12
Registered: March 2007
Junior Member
Thanks a lot for the help
Previous Topic: How does the query statement do?
Next Topic: Oracle DBA Fundamentals II (Note Sheets)
Goto Forum:
  


Current Time: Tue Dec 06 08:23:46 CST 2016

Total time taken to generate the page: 0.07384 seconds