STREAMS_MIGRATION Procedure

Generates a migration script that migrates an Advanced Replication environment to a Streams environment. Specifically, this procedure generates a script that sets up a Streams environment for the specified replication groups. The generated script can be customized and run at each master site to perform the migration.

See Also:

Oracle Streams Replication Administrator's Guide for detailed information about migrating from Advanced Replication to Streams

Syntax

DBMS_REPCAT.STREAMS_MIGRATION ( 
     gnames              IN   DBMS_UTILITY.NAME_ARRAY, 
     file_location       IN   VARCHAR2, 
     filename            IN   VARCHAR2);

Parameters

Table 18-132 STREAMS_MIGRATION Procedure Parameters

Parameter Description

Parameter	Description
gnames	List of replication groups to migrate to Streams. The replication groups listed must all contain exactly the same master sites. An error is raised if the replication groups have different masters.
file_location	Directory location of the migration script. The specified location should be a directory object that is accessible to PL/SQL. You can use the SQL statement `CREATE` `DIRECTORY` to create a directory object. See Also: Oracle Database SQL Reference for more information about the `CREATE` `DIRECTORY` statement
filename	Name of the migration script

gnames

List of replication groups to migrate to Streams. The replication groups listed must all contain exactly the same master sites. An error is raised if the replication groups have different masters.

file_location

Directory location of the migration script. The specified location should be a directory object that is accessible to PL/SQL. You can use the SQL statement CREATE DIRECTORY to create a directory object.

See Also: Oracle Database SQL Reference for more information about the CREATE DIRECTORY statement

filename

Name of the migration script