"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
news:MPG.19105d657249705e98974a_at_news.la.sbcglobal.net...
| "Chris \( Val \)" <chrisval_at_bigpond.com.au> said...
| >
| > "Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
| > news:MPG.190f086695a37db2989746_at_news.la.sbcglobal.net...
| > | "Chris \( Val \)" <chrisval_at_bigpond.com.au> said...
| > | >
| > | > I still have a lot to learn in Oracle, no doubt about it.
| > | >
| > | > I am trying to create a database link in PL/SQL using 9i
| > | > on one machine to 9i on another. I'm not sure I understand
| > | > these configuration files enough to do it without some help.
| > | >
| > | > Can you offer some suggestions to get me on the right track ?
| > | >
| > | > Thanks.
| > | > Chris Val
| > | >
| > | Using sqlplus on the source database, you create a database link to the
| > | target database. You only have to do this once, so PL/SQL is probably
| > | not the best choice; use sqlplus.
| > |
| > | You use a different syntax depending on whether you want to connect as
| > | the same userid (an identical Oracle userid must exist on both the
| > | source and the target db) or as a different userid (in which case, you
| > | supply the userid/password in the database link).
| > |
| > | You can find the syntax in the SQL Reference manual at tahiti.oracle.com
| > | (create database link <name>...).
| >
| > Hi Karsten.
| >
| > My problem is not really the syntax, as shown below, that
| > seems fairly straight forward. My problem however, is that
| > I'm not sure how to configure the 'sqlnet_string' below.
| >
| > CREATE DATABASE LINK link_name
| > CONNECT TO username IDENTIFIED BY password
| > USING sqlnet_string;
| >
| > I'll have a look in the reference manual you suggested, but
| > if you think its a fairly simple thing to do, then I would
| > be glad to see a brief example if possible ?.
| >
| > Thank you for your help.
| >
| > Cheers.
| > Chris Val
| >
| You probably already discovered this while I was home (no, I don't work
| 24 hours a day), but...
|
| The "sqlnet_string" is the tnsnames.ora alias name you assigned. For
| example, if you have the following entry in the tnsnames.ora file on
| your source computer:
|
| target_db = (description...
|
| Then you create your database link on the source computer like this:
|
| create database link target_link
| connect to scott identified by tiger
| using 'target_db';
Hi Karsten, thanks for the tips.
I did some reading about this 'tnsnames.ora' file, and your reply
confirms that is what I need to configure. I will try this out over
the weekend, and see how I get on :-).
Thanks again.
Chris Val
Received on Thu Apr 24 2003 - 08:57:20 CDT