From oracle-l-bounce@freelists.org Tue Jun 21 14:31:27 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5LJVRn7031716 for ; Tue, 21 Jun 2005 14:31:27 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5LJVRNi031712 for ; Tue, 21 Jun 2005 14:31:27 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 92CA21C2121; Tue, 21 Jun 2005 13:28:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24051-06; Tue, 21 Jun 2005 13:28:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 072C81C08E8; Tue, 21 Jun 2005 13:28:01 -0500 (EST) From: "Eric Buddelmeijer" To: , Subject: RE: Index Partition Load Question Date: Tue, 21 Jun 2005 20:26:05 +0200 Organization: Elegant Apllication Services MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0027_01C5769F.73A10FE0" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Thread-Index: AcV2jGyiQGBb779XRU2nNsw6tSP35gAAZ7BA In-Reply-To: <9AD5E2398D7F4744832116BA0802B64407BDF13D@dcempf2.phs.com> Message-Id: <20050621182611.MKSM1226.amsfep20-int.chello.nl@wst116> X-archive-position: 21441 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Eric.Buddelmeijer@elegant.nl Precedence: normal Reply-To: Eric.Buddelmeijer@elegant.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.3 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_0027_01C5769F.73A10FE0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Try partition exchange. Load the data into a table with the exact same layout as your partitioned table excluding the indices, except the table is not partitioned. Load your data into that table with the intermediate commits. Create the indices (exact same name and columns and bitmapped or not) and do the partition exchange. Nobody notices you being busy, the partition just 'suddenly' (second) is filled. Love it. Kind regards, Eric. _____ Van: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] Namens Pierce Vicki C Verzonden: dinsdag 21 juni 2005 20:11 Aan: oracle-l@freelists.org Onderwerp: 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. ------=_NextPart_000_0027_01C5769F.73A10FE0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Index Partition Load Question
Try partition exchange.
Load the data into a table with the exact same = layout as=20 your partitioned table excluding the indices, except the table is not=20 partitioned. Load your data into that table with the intermediate = commits.=20 Create the indices (exact same name and columns and bitmapped or not) = and do the=20 partition exchange.
Nobody notices you being busy, the partition = just=20 'suddenly' (second) is filled. Love it.
 
Kind regards,
Eric.


Van: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] Namens Pierce Vicki=20 C
Verzonden: dinsdag 21 juni 2005 20:11
Aan:=20 oracle-l@freelists.org
Onderwerp: Index Partition Load=20 Question

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

The problem is I have a partitioned table = with local=20 partitioned bitmap indices. I am loading a single partition of the = table. I want=20 to disable the rebuild of indices in that partition until the load = completes.=20 The load process does intermediate commits so that I need a method of = stopping=20 the index rebuild/update until the entire load process completes. If I = make the=20 index partition unusable, the load cannot be done. I am looking for a = method of=20 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=20 information from PacifiCare Health Systems Inc. which may be = confidential or=20 privileged. The information is intended to be for the use of the = individual or=20 entity named above. If you are not the intended recipient, be aware that = any=20 disclosure, copying, distribution or use of the contents of this = information is=20 prohibited.
If you have received this electronic transmission in = error,=20 please notify the sender immediately by a "reply to sender only" message = and=20 destroy all electronic and hard copies of the communication, including=20 attachments.

------=_NextPart_000_0027_01C5769F.73A10FE0-- -- http://www.freelists.org/webpage/oracle-l