Re: Q: Moving data to partition tables

The quickest probably would be to do an exchange partition. i.e. What you need is the new table partitioned(which is basically a copy current table but with partitions). The caveat is that when you do an exchange partition, Oracle will only exchange the non-partitioned table into only one partition of the partitioned table. So, if you need to have smaller partitions, you'll have to have one huge partition, then after the exchange partition finsihes, you'll need to do split partition.

HTH,
Pete's

The views I may have expressed here are solely my own and not that of my employer.

Kalle <kminerva_at_jippii.fi> wrote in message news:<3EDB17BD.52AB6E5_at_jippii.fi>...
> Hi all,
>
> do you know how to speed the data load from "ordinary" tables to the
> partitioned tables. I have a huge amount of data and it seems to be very
> slow.
>
> What might be the quickest way to do this kind of change...
>
> Kalle
Received on Mon Jun 02 2003 - 13:29:05 CDT