As described in the beginning of the tutorial, the health care provider requires to archive data in a quarterly basis. It now reaches the time to perform the archive.
Operation
Roll-out operation is demonatrated here.
Solution
The health care provider can now roll out data from 2009-01-01 to 2009-03-31 with the
ALTER TABLE ... DETACH command. The detached data is stored in the OPD_20090q1 table.
This table is like any other regular table that can be backed up as desired.
Best Practices ::