OraFAQ Forum: Server Administration » ORA-01536: space quota exceeded for tablespace

Home » RDBMS Server » Server Administration » ORA-01536: space quota exceeded for tablespace

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

ORA-01536: space quota exceeded for tablespace [message #239786]

Wed, 23 May 2007 05:20

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.

Report message to a moderator

Re: ORA-01536: space quota exceeded for tablespace [message #239789 is a reply to message #239786]

Wed, 23 May 2007 05:26

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-01536: space quota exceeded for tablespace [message #239793 is a reply to message #239789]

Wed, 23 May 2007 05:45

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?

Report message to a moderator