Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle streams

RE: Oracle streams

From: Fedock, John \(KAM.RIC\) <>
Date: Thu, 18 Oct 2007 14:40:55 -0400
Message-ID: <>

Thanks for the quick responses. I don't expect anyone to spend a great amount of time helping me, but if you have a quick answer to these, I would appreciate it.  

  1. The state of the capture is "Capturing changes" - which is good. When I update my test tables, where are the changes stored? I assume it is my streams_queue_table table, but that is empty.
  2. On the target database, I see 2 error messages that say - ORA-26687: no instantiation SCN provided for "CONT"."xxxx" in source database
    "YYYYYY". I did instantiate the object. No doubt about it. I am not
    sure why this is here.

From: Weatherman, John [] Sent: Thursday, October 18, 2007 11:54 AM To: Fedock, John (KAM.RIC); Subject: RE: Oracle streams  


What are you doing where now? There are a LOT of ways to set this up. Can you provide a test script? Do you have schema and object rules (these can conflict)? Have you used grid control to set up a development system? The save scripts option isn't optimal, but gives a good starting point. Have you opened a SR with Oracle? I actually found the Streams group to be fairly good. As it is, this question is too vague to help, other than just saying RTFM.  


John P Weatherman

Asurion Inc.  

From: Fedock, John (KAM.RIC) [] Sent: Thursday, October 18, 2007 10:27 AM To:
Subject: Oracle streams  

Looking to see if people are successfully using streams to move data between 2 databases. This would be on 10g, HP-UX machines.  

I have attempted a few test cases and have not been able to get the data to move over. I am still not grasping creating the capture, adding table rules, creating apply process, instantiating the scn, etc.  

Does anyone have a checklist on which task to do on what server (source vs destination)? I have been looking at metalink note 298877.1 and the session 249 from collaborate 2007.    

Thanks all,  

John Fedock

"K" Line America, ISD Department

Received on Thu Oct 18 2007 - 13:40:55 CDT

Original text of this message