if you want to use the same tablespace as the tablespace used by your source table you may use exchange partition.
If your target partition should be on a different tablespace or if you want to use different storage parameters you may either do an
an alter table move and an exchange partition
an insert append
Insert / +append / does faster copy of data from one table to another. It might take within 2 min to insert 16M records. I am not sure about the partition stuff.
That totaly depends on the amount of data, of the available HW ressources, of the number of indexes...
Originally Posted by srt
Also using the "partition stuff" to move the data to the partitioned table would probably take less then 10 secondes if the indexes has not to be rebuilt and the source table is not partitioned (=> target partition is not subpartitioned).
Click Here to Expand Forum to Full Width