Table partition backup - restore strategy
497418Jun 21 2007 — edited Jul 30 2007Dear All,
We have a half OLTP system handling huge amount of data on daily basis. Range+list composite partitions are used for the core tables with monthly partition ranges. There is a need to remove data older than 2 months, so we need to drop the partitions. The question regarding to this is the following:
What is the best way for backing up and restoring the partitions (not all of them) if needed? Sometimes we have to restore few months (on the same or a different oracle instance) in order to examine the records.
We have found usable ways to complete this scenario, but I'm curious about the solutions proposed by you.
Thanks in advance.
Franky