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
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,

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

Current Time: Tue May 21 14:57:25 CDT 2024