Re: loopback connection

cvandecasteele_at_tis.be (Carl Van de Casteele) wrote: [...]

Try

  create public database link mydb_at_mydb;

This assumes that your DB_NAME is "mydb" and that you want the dblink session to use the userid/pw with which you are already logged on. I believe it also requires that you use GLOBAL_NAMES=TRUE. If you want the dblink session to use a different userid/pw, try

  create public database link mydb_at_mydb connect to fina2   identified by fina2;

This assumes that fina2/fina2 is a valid userid/pw combination.

/b

--
Bill Manry - IBM Products Division - Oracle Corp. USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.