RE: Oracle streams

  • From: "Fedock, John \(KAM.RIC\)" <John.Fedock@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 18 Oct 2007 14:40:55 -0400

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 [mailto:John.Weatherman@xxxxxxxxxxx] 
Sent: Thursday, October 18, 2007 11:54 AM
To: Fedock, John (KAM.RIC); oracle-l@xxxxxxxxxxxxx
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) [mailto:John.Fedock@xxxxxxxxxxxx] 
Sent: Thursday, October 18, 2007 10:27 AM
To: oracle-l@xxxxxxxxxxxxx
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


Other related posts: