Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Large data movement to new partitioned table

Re: Large data movement to new partitioned table

From: zhu chao <zhuchao_at_gmail.com>
Date: Thu, 20 Oct 2005 05:20:10 -0800
Message-ID: <962cf44b0510200620j2b19f2f4n222fba9f55252de5@mail.gmail.com>


You might want to try exchange partition with table. This makes things extreme efficient.

On 10/19/05, Knight, Jon <jknight_at_concordefs.com> wrote:
> I have a couple of large tables (average 350,000 recs/day) that I need to
> move to a different schema. We have almost 1 year of data. They are
> currently traditional table structures and I'm moving them to partitioned
> tables. The table names are different between schemas.
> Regards

Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 20 2005 - 08:22:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US