Scenario

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 ::