-
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.
-
I don't see how the rowid could be expected to be the same on both databases.
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|