My Oracle Support Banner

RDBPROD: Simple example showing how to reload a table in SQL (Doc ID 1367335.1)

Last updated on MAY 08, 2020

Applies to:

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


In order to remove fragmented data it is necessary to unload and reload it.  Or, if it is necessary to make some changes that also require a reload, consider adapting or using a modified version of the following SQL script.

This script is more suited for smaller tables.

NOTE: The data used below (MF_PERSONNEL) is part of the Oracle Supplied Data, It is not an actual PRODUCTION or Customer Data.  It is solely for testing and purposes to only.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.