Business Intelligence (BI) Interface Guide › Business Intelligence Interface › Administration › Duplicating the Database

Duplicating the Database

Notes:

• This section is only relevant when configuring the BI Interface for installation on two separate databases
• This section is not executed by the user. The operations described here are performed automatically by scripts, and this is only an explanation of how they are implemented.

Because the system uses a capture process to replicate changes made to a database object from a source database to a target database, the target database must have a copy of the database object.

If the copy does not exist on the target database, the object must be instantiated on the target database before it can replicate changes. To instantiate an object means to create an object physically on a target database, based on an object on a source database. If the object to be instantiated is a table, then the objects at the source and destination databases need not be an exact match. However, if some or all of the table data is replicated between the two databases, then the data that is replicated should be consistent when the table is instantiated.

This instantiation is performed using the export/import utilities of the Oracle database. For the export of the objects, it is important that they to be consistent at a single point in time. This can be accomplished either by setting the export parameter OBJECT_CONSISTENT to 'y', or by setting the database in a read-only mode while exporting the data. When importing the needed object for the data replication, the parameter STREAMS_INSTANTIATION must be set to 'Y'.