Mark D Powell wrote:
> This exact same type of question has appeared before and I have posted
> on some possible alternates and their drawbacks. As Daniel and Ed
> pointed out: this is not a real good idea; however, we are all working
> from just only the barest of details of what you want to do. Perhaps
> if you explained what it is you need to accomplish and why you cannot
> just send the data from one database to the other then perhaps someone
> can provide more helpful information.
>
> Depending on the relationship between the objects in A and B one option
> might be to connect to A and perform the update and then via table
> triggers in A send the updates to B over a database link You now have
> an Oracle managed distributed transaction.
>
> Oracle replication from A to B might be an option.
> HTH -- Mark D Powell --
Exactly. I'm still not convinced the OP means database rather than
schema given the skill set posted.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
Received on Thu Dec 23 2004 - 23:09:45 CST
