Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Transformation ?

295269Sep 29 2003 — edited Oct 4 2003

I have a requirement here is what we are trying to do..

for example..

We have two database source and target..

Source DB have schema called src
Target DB have schema called trg

If I configure the schema name to be the same as the source database it work, :)

However I have XYZ schema object which I want to apply to only once schema on target. I know there is some type of transformation which need to be done before the apply process can take place..

Now my question is ..

How can I move data from db1 src.tablea to
db2.tar.tablea.
what is that I need to do so that I can accomplish this?

My second requirement is to treat every UPDATE AND DELETE as a NEW STATEMENT.

if anyone have done this .. I would appreicate if you can share your examples with me..

sakibnawaz@yahoo.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2003

Added on Sep 29 2003

#performance-availability, #streams

1 comment

285 views