Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Archiving partition tables

714955Feb 27 2011 — edited Mar 16 2011

Hi..

I'm looking for some suggestions for Data archiving in Oracle 10g from big data tables. We always handling millions of data. The table which is trying to archive is range partitioned and size is 451TB as of now. This table has more than 1.5billion records.

We are planning to move the data to history table, by keeping the 1 year data in original tables.

Which way is better to move the data from partitions to archiving tables.. data is required from archiving tables for reporting purposes.

Exchange partition is good way to move the data to new archiving tables ? or Inserting the data is better way using select clause??

Comments are highly appreciated.

Rgds
Kishore. N

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2011

Added on Feb 27 2011

#general-database-discussions

11 comments

5,202 views