RDBPROD: How to Move Non-Empty Tables Out of RDB$SYSTEM? (Doc ID 2212378.1)

Last updated on DECEMBER 08, 2016

Applies to:

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

Goal

How to move non-empty tables out of RDB$SYSTEM? A number of tables have been created and populated over time, with no storage maps ever defined. The decision has now been made to move the data to separate storage areas.
 

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