Re: Accessing Tables from multiple instances

From: Oracleguru <oracleguru_at_mailcity.com>
Date: Wed, 05 Aug 1998 16:01:41 GMT
Message-ID: <01bdc09a$018a9d80$a504fa80@mndnet>

Here are the instrunctions I wrote for our department when we had two machines( network nodes SUN1 and SUN2) and two different instances PROD and DEV. Use what you want according to your set up.

---

Log into SQL*Plus on SUN1 under your Oracle userid. If you don't have the password create one as given below:

alter user ops$xyz
identified by xyz1;

---

Log into SQL*Plus on SUN2 under your Oracle userid.

Create the private database link PROD to access the Oracle instance on SUN1 as given below:
DBAs also can create public database links.

create databse link prod

connect  to               ops$xyz     /* Userid on SUN1 */
identified  by            xyz1           /* Password on SUN1 */
using                       'PROD';       /* If you have SQL*Net  v.1 use

't:dgc2:prod' */

---

Now if you want to look at or copy a table from PROD on SUN1 and you are logged into SQL*Plus on SUN2, here is all you have to do:

select * from table_on_sun1_at_prod;

create table_on_sun2
as
select * from table_on_sun1_at_prod;

---

You are logged into SUN2, but temporarily want to work with any objects in Oracle instance PROD on SUN1, then use SQL*Plus as given below on SUN2.

At OS prompt:

sqlplus ops$xyz_at_prod

This will prompt you for your password on PROD.

You can also use.

sqlplus /@prod

There are no spaces bewtween /, @ and prod.

SQL*Net v1, use:

sqlplus ops$xyz@'t:dgc2:prod' OR
sqlplus ops$xyz_at_t:dgc2:prod

Hope this helps !!!

Oracleguru

Training Dept <mark_at_elitetraining.com> wrote in article <01bdc077$12250860$340a0a0a_at_pc052>...
> This may be a silly question, but, is there any way for a client to
access
> two tables from two different instances in SQL*Plus
>
> We are running Oracle 7.3.2.3.10 on Netware 4.11 and SQLNET 2.???? over
> TCP/IP
>
> TIA
>
>
>
Received on Wed Aug 05 1998 - 11:01:41 CDT