[Amit Bansal]

–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]

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

[Author]

Posts