Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Getting rid of ConText Indices with huge queues...
Hi, seems that ConText hates me... ;-)
I have several tables for which ConText Policies and Indices exist, however, they are not needed. So I would like to get rid of them with ctx_ddl.drop_index and ctx_ddl.drop_policy. However, the dml_queue for those policies are rather big (several million entries). Now what happens when issuing a drop_index statement is...it takes hours for complete. Unfortunatelly, I have a dozen policies for which this is true. Do I really have to wait for several days?
Or is there a smarter way of deleting those policies and indexes?
Thanks for any hint, Gerhard.
PS: No, I do not really want to drop the tables themselves, as to recreate them takes a long time as well. ;-)
-- Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE ICQ PIN: 2804938 OFFIS | | | | | | Tel.: 0441/9722-122 Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101 D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102Received on Thu Feb 12 1998 - 00:00:00 CST
![]() |
![]() |