Tablespace quota

Hi All,
        I am recieving the below error from Oracle AQ. The Aq  user has Unlimited tablespace role.

oracle.jms.AQjmsException: ORA-00604: error occurred at recursive SQL level 1
ORA-01536: space quota exceeded for tablespace 'AQ_DATA_1'
ORA-06512: at "SYS.DBMS_AQIN", line 344
ORA-06512: at "SYS.DBMS_AQIN", line 1098
ORA-06512: at line 1

        at oracle.jms.AQjmsProducer.enqueue(AQjmsProducer.java:1158)
        at oracle.jms.AQjmsProducer.send(AQjmsProducer.java:585)
        at oracle.jms.AQjmsProducer.send(AQjmsProducer.java:451)

Can you let me how to fix this?

Thanks,
Cavaturu
cavaturuAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
seazodiacConnect With a Mentor Commented:
that's the PROBLEM.

the user AQ has unlimited tablespace quota in the tablespace "AQ_D_1".

you have to make sure AQ has the same permission on the tablespace 'AQ_DATA_1'

log in as sysdba

SQL>alter user AQ quota unlimited on AQ_DATA_1;
0
 
seazodiacCommented:
well, can you post the result of following query?

log in as sysdba:

SQL>select username, defaullt_tablespace, temporary_tablespace from dba_users where username='AQ';
0
 
cavaturuAuthor Commented:
AQ,AQ_D_1,TEMP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.