List:General Discussion« Previous MessageNext Message »
From:Bryan Cantwell Date:July 23 2010 3:02pm
Subject:Archive data from a single partition
View as plain text  
I have a very large table (over 2 billion rows) which is partitioned by
day. I'd like to archive all the data in the oldest partition to another
table before I drop that partition. Is there some way other than a
simple select statement that has parameters that match those of the
partition whic will allow me to copy all data in a single partition over
to another table?


Archive data from a single partitionBryan Cantwell23 Jul