| 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? Thanks, Bryancan
| Thread | ||
|---|---|---|
| • Archive data from a single partition | Bryan Cantwell | 23 Jul |
