Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Getting rid of ConText Indices with huge queues...

Getting rid of ConText Indices with huge queues...

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1998/02/12
Message-ID: <6bv7vb$gem@news.Informatik.Uni-Oldenburg.DE>#1/1

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-102
Received on Thu Feb 12 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US