| Oracle Queue tables gets corrupted [message #602240] |
Mon, 02 December 2013 06:08  |
|
|
Hi,
Please note in my database oracle queue table gets corrupted SYS"."SYS_IOT_TOP_8864 please advice can we drop this index if yes,Kindly advice how to drop.
Structure of index for reference:
CREATE UNIQUE INDEX "SYS"."SYS_IOT_TOP_8864" ON "SYS"."AQ$_ALERT_QT_T" ("NEXT_
DATE", "TXN_ID", "MSGID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSAUX"
Regards,
Anil
|
|
|
|
|
|
|
|
|
|
| Re: Oracle Queue tables gets corrupted [message #602247 is a reply to message #602243] |
Mon, 02 December 2013 06:56  |
|
|
Hi, Please find below
SQL> drop table AQ$_ALERT_QT_T;
drop table AQ$_ALERT_QT_T
*
ERROR at line 1:
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
SQL> EXECUTE DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'AQ$_ALERT_QT_T');
BEGIN DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'AQ$_ALERT_QT_T'); END;
*
ERROR at line 1:
ORA-24002: QUEUE_TABLE SYS.AQ$_ALERT_QT_T does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4103
ORA-06512: at "SYS.DBMS_AQADM", line 197
ORA-06512: at line 1
Please advce.
Regards,
Anil
|
|
|
|
| Re: Oracle Queue tables gets corrupted [message #602256 is a reply to message #602247] |
Mon, 02 December 2013 07:24 |
John Watson
Messages: 8961
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
That is the queue table used by the server alert system. If you have corrupted that, you may well have damaged other parts of your data dictionary too. If I were you, I would do a full export immediately, and import into a new database.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
