schema bi-directional replication
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',