tag:blogger.com,1999:blog-2654730833842815256.post8027259930010951209..comments2023-06-09T05:44:32.737-07:00Comments on Oracle Database: Streams 10gR2 Implementation -Table LevelKrishna Ramavathhttp://www.blogger.com/profile/10559149349784447921noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-2654730833842815256.post-74302558007959407052009-09-24T19:05:16.018-07:002009-09-24T19:05:16.018-07:00Hi Sumanth,
Thanks for suggestion. I will update ...Hi Sumanth, <br />Thanks for suggestion. I will update the post accordingly and will include the verification step as well.<br /><br />Thanks,<br />KrishnaKrishna Ramavathhttps://www.blogger.com/profile/10559149349784447921noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-26185025400222548922009-07-21T18:45:00.589-07:002009-07-21T18:45:00.589-07:00Hi Krishna,
Adding to the content you h...Hi Krishna,<br /><br /> Adding to the content you have, would you be able to post how to verify streams replication is going on fine and also a way to check all the tables that are being replicated...<br /><br />Thanks for your detailed post....it definitely helps...DSRhttps://www.blogger.com/profile/01699846456738489795noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-76307054677036970982009-03-18T12:22:00.000-07:002009-03-18T12:22:00.000-07:00Hello Krishna,Thanks for the step by step streams ...Hello Krishna,<BR/><BR/>Thanks for the step by step streams setup.<BR/><BR/>I followed the whole setup couple of times but didn't get succeeded, the changes I'm doing on source table is not reflecting on the target table.<BR/><BR/>The only change I did in the setup was, I created public db link instead of private and ignored step 1b as they are implemented in step 8 and 14, did they make any difference??<BR/><BR/>Please advice??<BR/><BR/>Thanks<BR/>Bharath Reddy.bharath reddyhttps://www.blogger.com/profile/08959526869656044511noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-62251061222165316872009-03-11T11:44:00.000-07:002009-03-11T11:44:00.000-07:00root.sh in AGENT_HOME...i.e., Run AGENT_HOME/root....root.sh in AGENT_HOME...<BR/>i.e., Run AGENT_HOME/root.sh , logged in as the root user.<BR/>-Bbharath reddyhttps://www.blogger.com/profile/08959526869656044511noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-17317419390682318392009-03-11T11:37:00.000-07:002009-03-11T11:37:00.000-07:00@renufor NMO not setuid-root (Unix-only,Run root.s...@renu<BR/><BR/>for NMO not setuid-root (Unix-only,<BR/>Run root.sh script to correct that problem.<BR/><BR/>-Bharath Reddy.bharath reddyhttps://www.blogger.com/profile/08959526869656044511noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-9022097166809120042009-02-10T16:42:00.000-08:002009-02-10T16:42:00.000-08:00If the schema name is different then you need to u...If the schema name is different then you need to use declarative transformation, using this you can replicate DML and partial DDL's. I am going to post shortly.Krishna Ramavathhttps://www.blogger.com/profile/10559149349784447921noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-27878197568090676912009-02-10T11:24:00.000-08:002009-02-10T11:24:00.000-08:00Could you please suggest me an idea.Here is my pro...Could you please suggest me an idea.<BR/>Here is my problem. I need to replicate some selected tables only from schema1 to schema2 in the same database. Where structure of schema1 and schema2 are same but we just need 120 tables out of 300 tables.<BR/><BR/>Then from schema2 to schema3 i need to replicate some tables. Where schema 3 has 90 tables. These 90 tables in schema3 has same structure as tables in schema2.<BR/><BR/>I included DDL's but they are not working. DML's are working fine. I followed your script. Could you please give us an example how to include DDL's as schema names are diff.<BR/><BR/>Thanks,<BR/>RayUnknownhttps://www.blogger.com/profile/04973737007359761439noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-28426266970912190012009-01-19T01:55:00.000-08:002009-01-19T01:55:00.000-08:00While implementing oracle streams I got this error...While implementing oracle streams I got this error NMO: non-set userid in unix please tell me how to get rid of it.renuhttps://www.blogger.com/profile/00032880300214140234noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-62118976120090678732009-01-19T01:53:00.000-08:002009-01-19T01:53:00.000-08:00Please post the solution of my problem to my maili...Please post the solution of my problem to my mailid if possible...<BR/>renu.ch09@yahoo.comrenuhttps://www.blogger.com/profile/00032880300214140234noreply@blogger.comtag:blogger.com,1999:blog-2654730833842815256.post-35641868344732036232009-01-13T16:44:00.000-08:002009-01-13T16:44:00.000-08:00Using EM you can eliminate these steps.Using EM you can eliminate these steps.Krishna Ramavathhttps://www.blogger.com/profile/10559149349784447921noreply@blogger.com