Solved

Tablespace quota

Posted on 2004-09-24
3
1,191 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:cavaturu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 23

Expert Comment

by:seazodiac
ID: 12144907
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
 

Author Comment

by:cavaturu
ID: 12145296
AQ,AQ_D_1,TEMP
0
 
LVL 23

Accepted Solution

by:
seazodiac earned 500 total points
ID: 12145379
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question