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:
*
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
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?
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?
0