Streams -> Apply process dependency on ROWIDs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Streams -> Apply process dependency on ROWIDs

  1. #1
    Join Date
    Jan 2002
    Posts
    148

    Streams -> Apply process dependency on ROWIDs

    Hello,

    I am in the process of evaluate as what to
    implement to achieve replication between cloned databases.

    VLSDs are cloned on Windows / LAN environment.

    If Streams were to impliment , then does the apply process
    on the target DB will use exact DML statement or it referes to
    the ROWID? If not is it possible ?

    example.
    # Source DB
    #Table A
    # Update A Set
    col1='xyz'
    col='xyz'


    Target DB
    Table A
    # what would apply process do here ????
    same DML ? or
    Update A Set
    where col2='012'
    where ROWID='xxx'





    If ROWID reference is used then updates is nowonder fast.

    Thanks
    Jr.
    Last edited by Jr; 08-02-2004 at 10:25 AM.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I don't see how the rowid could be expected to be the same on both databases.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2002
    Posts
    148
    Thanks for the reply,

    Please let me understand here...

    After Cloning both Databases have same ROWID,
    If ONLY updates were to replicate, then ROWID reference can be used.

    In case of DataGaurd ( Streams over Standby )
    will the Apply process in the standby database use rowid reference?
    ---------------------------------------------------------------------
    following is copy-paste from
    (http://www.cise.ufl.edu/help/databas...1/strmover.htm )
    Streams can capture changes made to a production system and send those changes to a staging database or directly to a data warehouse or operational data store. Streams capture of redo log information avoids unnecessary overhead on the production systems. Support for data transformations and user-defined apply procedures allows the necessary flexibility to reformat data or update warehouse-specific data fields as data is loaded.
    ---------------------------------------------------------------------
    Thanks
    Jr.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    That seems correct, but there are a couple of circumstances where updates can cause the rowid to change -- in partition row-movement, and in index organized tables.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width