drop user

Posted on 2016-09-18
Medium Priority
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
Question by:samith Hasaranga
  • 3
LVL 11

Accepted Solution

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.
LVL 11

Expert Comment

ID: 41825420
Did you try the way to resolve the original question? Thanks.
LVL 11

Expert Comment

ID: 41853454
No more update from the author.

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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.

Join & Write a Comment

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 setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

597 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