Home » RDBMS Server » Server Administration » import/export
import/export [message #62965] Sun, 29 August 2004 22:35 Go to next message
amitesh
Messages: 4
Registered: March 2004
Junior Member
hi all

I have two machine each with database.Both have the same service name ORCL.

Machine 1

MAchine 2

 i want to export data fo machine 2 from machine 1 through the export utility.I hav tries to connect to system/manager with alias but it connect to machine 1 itself . Can any one help me out in saolving this problem.

Regards

Amitesh
Re: import/export [message #62966 is a reply to message #62965] Sun, 29 August 2004 22:56 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Add an entry 'ORCL_MACHINE2' to your TNSNAMES.ORA file that connects to the correct machine.

MHE
Re: import/export [message #62975 is a reply to message #62966] Mon, 30 August 2004 02:53 Go to previous messageGo to next message
amitesh panda
Messages: 3
Registered: July 2004
Junior Member
Thanx ,but i hav already tried this it give me an errot tns:could no resolve service name.

But while i use this string in Sql prompt it connect to that perticular machine .
Re: import/export [message #62995 is a reply to message #62975] Tue, 31 August 2004 05:47 Go to previous message
Anu
Messages: 82
Registered: May 2000
Member
hi!
create a new host string for the machine2 using netmanager/net8assistant in machine1 and connect to machine2's database through that one. hope it helps u

anu
Previous Topic: plz help.Object comparision
Next Topic: Urgent help - Windows authentication for Oracle
Goto Forum:
  


Current Time: Fri Sep 27 08:23:08 CDT 2024