GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

schema bi-directional replication

edited Nov 15, 2011 6:58PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
 Hi All,

The requirement is to setup bi-directional schema level replication.I have used " DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS" to configure bi-directional schema replication. After configuring (strmadmin user,init.ora params,tnsnames.ora, dblinks) the env. for streams  I executed the procedure given below on db1 database as source.

begin
 DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
   schema_names               =>'nsp',
   source_directory_object    =>  'source_dir',
   destination_directory_object =>'dest_dir',
   source_database              => 'asterix.baypackets.com',
   destination_database         => 'thu.baypackets.com',
   dump_file_name               => 'export_nsp.dmp',
   capture_name                 => 'capture_source',
   capture_queue_table          => 'capture_source_table',
   capture_queue_name           => 'capture_source',
   propagation_name             => 'prop_source',

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center