Hi.. Lye san


I've try the following command, but it still doesn't work
since the data file of the table is offline (corrupted).


SQL> exec dbms_aqadm.stop_queue('MAJOR_QUEUE',true,true,false);

PL/SQL procedure successfully completed.

SQL> exec dbms_aqadm.drop_queue('MAJOR_QUEUE',true);
BEGIN dbms_aqadm.drop_queue('MAJOR_QUEUE',true); END;

*
ERROR at line 1:
ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: 'C:\MAIL3.DBF'
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2463
ORA-06512: at "SYS.DBMS_AQADM", line 162
ORA-06512: at line 1

SQL> exec dbms_aqadm.drop_queue_table('MAJOR_QTABLE');
BEGIN dbms_aqadm.drop_queue_table('MAJOR_QTABLE'); END;

*
ERROR at line 1:
ORA-24012: cannot drop QUEUE_TABLE, some queues in TEST.MAJOR_QTABLE have not
been dropped
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2670
ORA-06512: at "SYS.DBMS_AQADM", line 192
ORA-06512: at line 1


??