Hi,

I have some clarifications in creating the db link between two DB's. This is
the first time I'm trying to create it.

1. What is the pre-requisite before creating db link ? Is the netconfig
between these DB is required ?

2. Is there any performance issue when trying to access the remote object
thru db link.

Thanks in advance.

--
Message posted via http://www.dbmonster.com

Ravip via DBMonster.com wrote:
You need to configure a TNS alias in the TNSNAMES.ORA config file
located in $ORACLE_HOME/network/admin. The database will look for the
config file there. Once the TNS alias is defined, you can create the db
link using this alias.

There are some issues. You are transmitting data across the network. So
you may have to ensure you network is up to the task. And it helps if
you limit the amount of data returned through the db link. So try to
construct your query to filter as much data as possible on the remote
side before returning the data to the local db.


HTH,
Brian


--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

Ravip via DBMonster.com wrote:
In addition to Brian's answer there are multiple ways to create a
DB link. Read the docs about them and what they do so that you build
the one most appropriate for your requirement.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

"Brian Peasland" <dba (AT) nospam (DOT) peasland.net> schreef in bericht
news:46dfef38$0$13829$88260bb3 (AT) free (DOT) teranews.com...
<SNAP>

on your server that is....
Sounds logical, but I've seen people doing that on a client..... ;-)

Shakespeare