<div>
well, can you post the result of following query? 
 
log in as sysdba: 
 
SQL&gt;select username, defaullt_tablespace, temporary_tablespace from dba_users where username='AQ'; 

</div>

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';


<div>
<div class="content wysiwyg-content">
Hi All, 
&nbsp; &nbsp; &nbsp; &nbsp; I am recieving the below error from Oracle AQ. The Aq &nbsp;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 &quot;SYS.DBMS_AQIN&quot;, line 344 
ORA-06512: at &quot;SYS.DBMS_AQIN&quot;, line 1098 
ORA-06512: at line 1 
 
&nbsp; &nbsp; &nbsp; &nbsp; at oracle.jms.AQjmsProducer.enqueue(AQjmsProducer.java:1158) 
&nbsp; &nbsp; &nbsp; &nbsp; at oracle.jms.AQjmsProducer.send(AQjmsProducer.java:585) 
&nbsp; &nbsp; &nbsp; &nbsp; at oracle.jms.AQjmsProducer.send(AQjmsProducer.java:451) 
 
Can you let me how to fix this? 
 
Thanks, 
Cavaturu
</div>
</div>

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

Tablespace quota

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.