Friends How can I drop Queue tables.
DBMS_AQADM.DROP_QUEUE_TABLE (
queue_table IN VARCHAR2,
force IN BOOLEAN DEFAULT FALSE,
auto_commit IN BOOLEAN DEFAULT TRUE);
I tried but not working.SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(DEF$_AQCALL,TRUE,TRUE);BEGIN DBMS_AQADM.DROP_QUEUE_TABLE(DEF$_AQCALL,TRUE,TRUE); END; *ERROR at line 1:ORA-06550: line 1, column 35:PLS-00357: Table,View Or Sequence reference 'DEF$_AQCALL' not allowed in thiscontextORA-06550: line 1, column 7:PL/SQL: Statement ignoredCan anyone tell me how to drop them from my schema. Through Import I got it in my Schema.
- Regards
- Chirag Majmundar.../
Focus Infosys..
+919886169102
------------------------------------------------------------------------------------------------------------------------------------
Good Judgment Comes From Experience.Experiences Comes From Bad Judgments.
------------------------------------------------------------------------------------------------------------------------------------
Oracle LazyDBA home page