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
