DB_LINK

DB_LINK

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'PB' on August 29, 2001 at 23:59:48 EST:

Hi,

We have two Oracle database - one on UNIX (call it DB_A) and the other one on NT (be it DB_B). Both are Oracle 8i.

One application which primarily uses DB_B needs one table data from DB_A. I would like to avoid the copy of the table (with data dump) from DB_A to DB_B. Can I achieve the access of DB_A data (for a table) from the application using DB_LINK. The purpose of this access is purely READ_ONLY.

I am new to this link process and any help with how-to-do will be highly appreciated.

Hope to hear you soon,

Regards,

Follow Ups:

Re: DB_LINK joerg 01:53:54 9/03/01 EST (0)
Re: DB_LINK Fred 09:12:01 8/30/01 EST (0)

Post a Followup

Name:
E-Mail:
Subject:
Message: : Hi, : We have two Oracle database - one on UNIX (call it DB_A) and the other one on NT (be it DB_B). Both are Oracle 8i. : One application which primarily uses DB_B needs one table data from DB_A. I would like to avoid the copy of the table (with data dump) from DB_A to DB_B. Can I achieve the access of DB_A data (for a table) from the application using DB_LINK. The purpose of this access is purely READ_ONLY. : I am new to this link process and any help with how-to-do will be highly appreciated. : Hope to hear you soon, : Regards, : PB