Re: Oracle streams

From: goran bogdanovic <goran00_at_gmail.com>
Date: Fri, 19 Oct 2007 13:35:12 +0200
Message-ID: <6d0a3ba80710190435n351a5919i7827ff3675fca1e6@mail.gmail.com>

for table instantination try:

declare
  iscn number; -- var which hold instantiation scn value begin
  iscn := dbms_flashback.get_system_change_number();

  sys.dbms_apply_adm.set_table_instantiation_scn_at_xxxx (
    source_object_name    => 'yyyy.t1',
    source_database_name  => 'fffff',
    instantiation_scn     => iscn);

end;

regards,

On 10/18/07, Fedock, John (KAM.RIC) <John.Fedock_at_us.kline.com> wrote:
>
> 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_at_asurion.com]
> *Sent:* Thursday, October 18, 2007 11:54 AM
> *To:* Fedock, John (KAM.RIC); oracle-l_at_freelists.org
> *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_at_us.kline.com]
> *Sent:* Thursday, October 18, 2007 10:27 AM
> *To:* oracle-l_at_freelists.org
> *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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 19 2007 - 06:35:12 CDT