Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    11

    Unanswered: 11g streams rows are not inserted

    I have setup the streams for six tables to propagate the data from source database to the destination database. But today I added one more table to it's configuration to get the data transferred. But the stream is not inserting records into the destination table. I can see that it throwing error when trying to update the non-existing records. The records are non-existing because it is not able to insert. I do not see any issue with the configuartion, it worked fine in the test environment but when we moved to production, it did not work. Any help would be highly appreciate as it is a production issue.

    Thanks,

  2. #2
    Join Date
    Sep 2009
    Posts
    11
    It seems strange to me that I had to write a DML handler for this issue. Even though no DML handler should be required, as per the documentation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •