RE: Oracle streams
- From: "Weatherman, John" <John.Weatherman@xxxxxxxxxxx>
- To: "'John.Fedock@xxxxxxxxxxxx'" <John.Fedock@xxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 18 Oct 2007 14:12:14 -0500
How did you instantiate the table? Data Pump? You did use
'DBMS_DATAPUMP.SET_PARAMETER(handle1, 'FLASHBACK_SCN', ############);'? It
sounds like the target didn't create the tables properly for some reason. I
have had similar problems in the past and found dropping the config and
rebuilding everything was necessary to get past it.
_____
From: Fedock, John (KAM.RIC) [mailto:John.Fedock@xxxxxxxxxxxx]
Sent: Thursday, October 18, 2007 1:41 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle streams
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
John,
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
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:
