Reg Oracle Streams Implementation..

Anonymous

Posts: 1
offline
Reputation:2

Posted 3 years ago
#

--I need to create streams in a single database but between diff schema's.
--from schema1 to schema2 ,Then schema2 to schema3 and schema4.
--schema1 has 500 table
--schema2 has 500(need to replicate 150 tables)
-schema3 has 90 tables
--schema4 has 100 tables

--Schema1 and Schema2 have same structure but i need to select only 150 tables out of 500 tables.
--from schema2 to schema3 ,here also structure is same. But i need to replicate 90 tables in schema3 .
--from schema2 to schema4 destination tables has extra columns.here iam using dml handlers.

My ques are:
I included DDL's. But they are not working.
Please give me some idea in this situation.

Thanks,
Ray
Amit Bansal

Oracle DBA
Joined: Jun '08
Posts: 73
offline
Reputation:96

Posted 3 years ago
#

Ray,

I would suggest going through below link which explains filtering the tables to exclude them from replication

http://prodlife.wordpress.com/2008/02/21/oracle-streams-replication-example/

Cheers
Amit

Cheers
Amit
http://askdba.org/weblog/

Reply

You must log in to post.