You might get this error while dropping a schema or tablespace or objects it self.
You need to drop using sys user with following syntax
execute DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'kmaedq_edqstaging.AQ$_EDQ_TOPIC_TAB_G', force => true);
Just mention the tablename in queue_table including schema name.
Now you can drop the object
You need to drop using sys user with following syntax
execute DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'kmaedq_edqstaging.AQ$_EDQ_TOPIC_TAB_G', force => true);
Just mention the tablename in queue_table including schema name.
Now you can drop the object
No comments:
Post a Comment