RE: Index Partition Load Question
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <Vicki.Pierce@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Jun 2005 13:28:46 -0500
make it unusable and then issue alter session set
skip_unusable_indexes=true.
Ken Naim
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Pierce Vicki C
Sent: Tuesday, June 21, 2005 1:11 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
