Re: Oracle streams

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@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@xxxxxxxxxxxx> 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@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: