Database Administration (MOSC)

MOSC Banner

unable to drop user, getting error of advance queue table does not exist

when trying to drop user , Getting error
drop user user_name cascade;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24002: QUEUE_TABLE  does not exist

as queue table is already dropped so when trying to drop queue and queue table, getting following error:
exec DBMS_AQADM.DROP_QUEUE('queue name');
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_AQADM", line 627

execute DBMS_AQADM.DROP_QUEUE_TABLE(QUEUE_TABLE=>'queue table_name',force =>TRUE);
*
ERROR at line 1:
ORA-24002: QUEUE_TABLE table_name does not exist
ORA-06512: at "SYS.DBMS_AQADM", line 707

what should be the possible solution for it?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center