SET INSTANTIATION CSN

Use SET INSTANTIATION CSN on your target database to set the instantiation CSN manually. This command requires DBLOGIN. It enables a Replicat with the DBOPTIONS ENABLE_INSTANTIATION_FILTERING option to filter out records below the specified CSN for any object without Oracle data pump import instantiation information. It is an alternative to specifying @FILTER(@GETENV('TRANSACTION','CSN').

To enable instantiation SCN filtering, you must do the following:

  1. Your Replicat parameter file must contain DBOPTIONS ENABLE_INSTANTIATION_FILTERING.

  2. The instantiation SCNs must be set at the target database for each table.

    You can do this using one of the following two methods:

    Automatically set the source SCN by the Oracle data pump upon import if the tables were prepared at the source database using ADD TRANDATA PREPARECSN or ADD SCHEMATRANDATA PREPARECSN prior to the Oracle data pump export.

    or

    Manually set the instantiation source SCN at the target database using this command.

Syntax

SET INSTANTIATION CSN *csn* FOR [*schema*.]*table* FROM *source-database-name*

csn

The CSN number that instantiation will begin.

[schema.]table

The name of the table to set the instantiation CSN on. If no schema is provided, the DBLOGIN user is used.

source-database-name

The global name of the source database for which this is a target.

Example

SET INSTANTIATION CSN 12345678 FOR hr.employees FROM orcl.com