Re: Names Servers - How To Remove

"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>...).

-- 
/Karsten
DBA > retired > DBA