-
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
or
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.
-
Originally Posted by srt
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...
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).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|