Re: Large data movement to new partitioned table
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: jknight@xxxxxxxxxxxxxx
- Date: Thu, 20 Oct 2005 05:20:10 -0800
You might want to try exchange partition with table. This makes things
extreme efficient.
On 10/19/05, Knight, Jon <jknight@xxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
