Reg Oracle Streams Implementation.. This topic contains 1 reply, has 0 voices, and was last updated by Amit Bansal 10 years, 7 months ago. Author Posts 10 February, 2009 at 7:41 pm #1884 Amit BansalKeymaster –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 11 February, 2009 at 7:09 pm #2048 Amit BansalKeymaster 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 You must be logged in to reply to this topic.