Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 51
  • Last Modified:

drop user

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
samith Hasaranga
Asked:
samith Hasaranga
  • 3
1 Solution
 
HuaMinChenBusiness AnalystCommented:
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
 
HuaMinChenBusiness AnalystCommented:
Samitch,
Did you try the way to resolve the original question? Thanks.
0
 
HuaMinChenBusiness AnalystCommented:
No more update from the author.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now