Home » SQL & PL/SQL » SQL & PL/SQL » Create public Database link
Create public Database link [message #222291] Fri, 02 March 2007 12:34 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member
I have two computers at my training lab. Both have computer Oracle 9i install. Bith have service/tag cats.

1.)
Computer Name : 10227-mr-srv.abc.com
Oracle service name : cats

2.)
Computer Name : 10227-ocrsrv.abc.com
Oracle service name : cats


Now from 1st oracle server, I want to connect to 2nd oracle server.

May be using fixed user hr Password hr_1.

Can you please give exact CREATE PUBILC DATABASE LINK statement for same.

May have to use identifier as creating loop.
Re: Create public Database link [message #222293 is a reply to message #222291] Fri, 02 March 2007 12:38 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
We can't give you an answer until we see your TNS entries. You are going to have to have GLOBAL_NAMES=FALSE in order to be able to do what you want as your database link will be called something other than the name of the database.
Re: Create public Database link [message #222294 is a reply to message #222291] Fri, 02 March 2007 12:40 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Are you incapable or unwilling to read the Fine SQL reference manual on your own?
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5005.htm#SQLRF01205
Re: Create public Database link [message #222303 is a reply to message #222294] Fri, 02 March 2007 13:23 Go to previous messageGo to next message
IT Guru
Messages: 59
Registered: January 2007
Member
I am learning just for 1 1/2 months.

I am learning from Oracle authorised training patners.

But their tutor is unable to explain at all. He skip saying not imp topic.

I along with tutor tried many diffrent syntex , which found online but none work.

Right now I am not in my training center to give you exact word to word error messeges.

If any more info require let me know.

anacedent wrote on Fri, 02 March 2007 12:40
Are you incapable or unwilling to read the Fine SQL reference manual on your own?
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5005.htm#SQLRF01205


Re: Create public Database link [message #222312 is a reply to message #222303] Fri, 02 March 2007 15:14 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
IT Guru wrote on Fri, 02 March 2007 14:23

But their tutor is unable to explain at all. He skip saying not imp topic.

I along with tutor tried many diffrent syntex , which found online but none work.



I don't know, maybe it's just me, but the irony of those two lines together bring a smirk to my face.

The info I gave you in the first response is what you will need.
Previous Topic: Loading the .csv file into the database table
Next Topic: PL/SQL tables
Goto Forum:
  


Current Time: Sat Dec 10 18:43:39 CST 2016

Total time taken to generate the page: 0.11637 seconds