RDBPROD: How can a significant amount of data be removed with the minimal amount of disruption?

(Doc ID 1460562.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2.1 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Goal

A table with a significant amount of data needs to reduced by archiving a portion of the data. This might be to address a performance issue or a space issue.

The requirement is to perform the archiving with miniminal disruption to production users. Only a small offline time window is available.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms