Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

drop user

Posted on 2016-09-18
3
Medium Priority
?
49 Views
Last Modified: 2016-10-21
When i try to drop user, I get the following error.
drop user user1 cascade;
ORA-24008: queue table user1.DEF$_AQERROR must be dropped first
0
Comment
Question by:samith Hasaranga
  • 3
3 Comments
 
LVL 11

Accepted Solution

by:
HuaMinChen earned 2000 total points (awarded by participants)
ID: 41803717
Please use DBMS_AQADM.DROP_QUEUE_TABLE procedure to drop the specified queue table first; then, retry the operation.

Here is note of DROP_QUEUE_TABLE procedure.
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_aqadm.htm#i1011453
0
 
LVL 11

Expert Comment

by:HuaMinChen
ID: 41825420
Samitch,
Did you try the way to resolve the original question? Thanks.
0
 
LVL 11

Expert Comment

by:HuaMinChen
ID: 41853454
No more update from the author.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

963 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