Saturday, February 27, 2016

ORA-24005: Inappropriate utilities used to perform DDL on AQ table

SQL> drop table SYSMAN.MGMT_LOADER_QTABLE cascade constraints;
                  *
ERROR at line 1:
ORA-24005: Inappropriate utilities used to perform DDL on AQ table SYSMAN.MGMT_LOADER_QTABLE





execute DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'SYSMAN.MGMT_NOTIFY_INPUT_QTABLE', force => true);

select 'execute DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => ' ||owner||'.'||table_name||' , force => true) ;' from dba_LOBS WHERE TABLESPACE_NAME='MGMT_TABLESPACE';

1 comment:

Everyone | To Get The Job | Database | All

  https://whatsapp.com/channel/0029Vb7B0Ew9MF98L2ER273b This Group help to Everyone , who are looking for the job  Also share with me if any...