| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Communication Between Two Instances
Rona Crystal wrote:
>
> I have two separate projects which we are doing in separate Oracle
> instances. However, occasionally it will be necessary for a process
> (probably implemented in Oracle Forms) to do a simple query against a
> table in the other instance.
>
> Is there a way to implement this and if so, where is it documented.
>
> Thanks for any help,
> Rona Crystal
>
> --
> =====================================================================
> Note: My email address has been modified to discourage unsolicited
> commercial and offensive email that is sent by bulk mailers. To
> respond personally to this post, remove all strings beginning and
> ending with #. i.e. j#xx#doe_at_my#yy#comp.com becomes jdoe_at_mycomp.com
> ---------------------------------------------------------------------
> All opinions expressed here are mine alone and do not reflect
> the opinion of any other individual or organization.
> =====================================================================
Rona,
You could define a database link from instance 1 to instance 2
In instance 1 :
create database link <linkname> connect to <user> identified by <passwd> using <connect string>;
then you can select in instance 1 tables from instance 2 :
select ... from table_at_linkname
where ...
Leo
 |
 |