RDBPROD: How to Move RDB$CHANGES Out of the RDB$SYSTEM or Default Storage Area

(Doc ID 66358.1)

Last updated on OCTOBER 27, 2017

Applies to:

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

Goal

In version 7 of Replication Option for Rdb, you are now able to move the RDB$CHANGES table out of the RDB$SYSTEM or default storage area if defined separately. How can this be accomplished? 

Note: To determine the default storage area use the SHOW STORAGE AREA command after attaching to the database in SQL.

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