RE: Index Partition Load Question

Index Partition Load QuestionYou don't tell what version or whether it is EE or SE. If you have OEM, you can create a job the performs the load and and the rebuild with the rebuild conditional on the successful completion of the load job.

HTH,
Ruth

 -----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Pierce Vicki C
Sent: Tuesday, June 21, 2005 2:11 PM
To: oracle-l_at_freelists.org
Subject: Index Partition Load Question

I have a data warehouse load question that hopefully someone out here can answer:

The problem is I have a partitioned table with local partitioned bitmap indices. I am loading a single partition of the table. I want to disable the rebuild of indices in that partition until the load completes. The load process does intermediate commits so that I need a method of stopping the index rebuild/update until the entire load process completes. If I make the index partition unusable, the load cannot be done. I am looking for a method of stopping the index rebuild until the entire load is completed.'

Thanks in advance for your help.

Vicki Pierce
Database Administrator
IT Planning & Architecture
(714) 226-4003

This electronic message transmission, including any attachments, contains information from PacifiCare Health Systems Inc. which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited.
If you have received this electronic transmission in error, please notify the sender immediately by a "reply to sender only" message and destroy all electronic and hard copies of the communication, including attachments.

--
http://www.freelists.org/webpage/oracle-l