move data from one table to another - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: move data from one table to another

  1. #11
    Join Date
    Mar 2002
    Posts
    534
    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

  2. #12
    Join Date
    Nov 2003
    Posts
    89
    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.

  3. #13
    Join Date
    Mar 2002
    Posts
    534
    Quote 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
  •  


Click Here to Expand Forum to Full Width