RE: Partitioning Question (2 of several)
- From: Kevin Toepke <ktoepke@xxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 22 Mar 2004 14:40:48 -0500
That depends on the version and whether or not you specify UPDATE GLOBAL
INDEXES
With it "Oracle updates the global indexes on the table whose partition is
being exchanged. Global indexes on the table being exchanged remain
invalidated. If you specify the parallel_clause with the
update_global_index_clause, then Oracle parallelizes the index update, not
the exchange operation."
Kevin
-----Original Message-----
From: david wendelken [mailto:davewendelken@xxxxxxxxxxxxx]
Sent: Monday, March 22, 2004 2:15 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Partitioning Question (2 of several)
Thanks!
I had seen that command, but hadn't realized the implication of it!
I'm guessing that global indexes would still have to be brought up to date.
Would that occur automatically as part of the exchange command, or would
they have to be dropped and rebuilt afterwards?
-----Original Message-----
From: jtesta@xxxxxxxxxx
Sent: Mar 22, 2004 10:57 AM
To: oracle-l@xxxxxxxxxxxxx
Cc: davewendelken@xxxxxxxxxxxxx
Subject: Re: Partitioning Question (2 of several)
definitely consider using alter table exchange to lessen impact.
if you're not familiar with it, it lets you swap data between a partition
and a non-partitioned table. so you load the data into a "temp
non-paritioned table", build the needed indexes and then do the exchange,
and poof its there(ok pretty darn close to poof).
joe
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
