Re: Partitioning Question (2 of several)

From: david wendelken <davewendelken_at_earthlink.net>
Date: Mon, 22 Mar 2004 11:15:09 -0800 (PST)
Message-ID: <32518253.1079982912838.JavaMail.root@ernie.psp.pas.earthlink.net>

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_at_dmc-it.com
Sent: Mar 22, 2004 10:57 AM
To: oracle-l_at_freelists.org
Cc: davewendelken_at_earthlink.net
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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 22 2004 - 18:48:08 CST