Home » Server Options » Text & interMedia » Question about dropping partitions in Oracle Text
Question about dropping partitions in Oracle Text [message #162310] Thu, 09 March 2006 11:50
ericson077
Messages: 1
Registered: March 2006
Junior Member
Hi All,

I have partitioned tables with context indexes on them and I need to drop some older partitions. I would like to know what I should do with context index. Is this managed automatically by Oracle?

My concern is if either I have to rebuild indexes or not after dropping a partition. Please give me some assistance on how is the proper way to drop a partition in a table with context index, because the database is too large and rebuilding the indexes would take weeks.

Thanks in advance,
Eric.

Previous Topic: ORA-12801: error signaled in parallel query server P005
Next Topic: To Retrive The image from oracle 9i
Goto Forum:
  


Current Time: Wed Aug 20 00:21:07 CDT 2014

Total time taken to generate the page: 0.10033 seconds