Re: interesting problem

jdubuke_at_afcosystems.com (JD) wrote in message news:<54a43a6e.0109060551.d2801a4_at_posting.google.com>...
> Hi all,
> I have 2 databases for an MRP application - actually 2 different
> companies.
> When a record is inserted into a table in database 1, can I set up a
> trigger event to automatically update a table in database 2?
>
> If so, How do I reference the table in database2, since the same table
> name will also exist in database 1? I need to do this from within
> Oracle, since I have no access to the MRP sources to modify it there.
>
> Hope I stated the problem correctly,
> Jerry D

Yes you can. It will be probably slow though. Read up on database links for your second issue. You need to use the insert into table_at_database link syntax.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 07 2001 - 09:42:38 CEST