Home » RDBMS Server » Server Utilities » import
import [message #256635] Mon, 06 August 2007 03:22 Go to next message
shanthis
Messages: 6
Registered: June 2007
Location: Chennai
Junior Member
how to import using oracle 9i dump file available at remote system?
Re: import [message #256649 is a reply to message #256635] Mon, 06 August 2007 04:21 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you just test your skills here, or do you really need help about the issue? If so, we'll move it to appropriate Forum.
Re: import [message #256650 is a reply to message #256635] Mon, 06 August 2007 04:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

shanthis wrote on Mon, 06 August 2007 14:22
how to import using oracle 9i dump file available at remote system?


Not possible.
Re: import [message #257388 is a reply to message #256650] Wed, 08 August 2007 04:17 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

If you have oracle client installed on your remote machine then you can import the the data using the remote imp utility. for that you have to provide the username/password@tnsname on the username parameter.

Cheers
Sanka
Re: import [message #257397 is a reply to message #256635] Wed, 08 August 2007 04:38 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Sanka give an example.
An example is worth than thousand of words.

[Updated on: Wed, 08 August 2007 04:39]

Report message to a moderator

Re: import [message #257546 is a reply to message #257388] Wed, 08 August 2007 10:40 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
sanka_yanka wrote on Wed, 08 August 2007 03:17
If you have oracle client installed on your remote machine then you can import the the data using the remote imp utility. for that you have to provide the username/password@tnsname on the username parameter.

Cheers
Sanka



Sanka you talking about datapump network mode ?
Network mode is new in 10g .
Re: import [message #257564 is a reply to message #257397] Wed, 08 August 2007 11:50 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Arju wrote on Wed, 08 August 2007 05:38
Sanka give an example.

Sanka is correct. The remote import utility can be used to import the remote dump file. The tnsalias informs the import utility where to import the data. Sanka essentially already gave an example. From remote node (assuming an appropriate version of the import utility exists):

imp username/password@tnsalias file=export.dmp


Re: import [message #257579 is a reply to message #257564] Wed, 08 August 2007 12:28 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I'm getting hung up here with the semantics of "remote dump file." Is this file on a separate server? You cannot import a file that is remote. You either run the import from the server where the file exists or ftp the file to where you would like to do the import.

Where is the destination database?
Where is the dump file?
Where are you running the command from?
Re: import [message #257634 is a reply to message #257579] Wed, 08 August 2007 18:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I hope I'm not misunderstanding the OP's request/configuration. But if the OP has an export file on a remote server and the remote server also has the appropriate version of the import utility, then they can use that import utility to import that file into a remote database simply by configuring his/her Oracle net connection and running the following command from the remote server:

imp username/password@<tnsalias_of_destination_database> file=export.dmp

For example, the imp utility is on Node A, export.dmp file is on Node A and the destination database that it will be imported into is on Node B. This will work.

@OP Is this what you are looking to accomplish?
Re: import [message #257657 is a reply to message #257634] Wed, 08 August 2007 23:17 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ebrian wrote on Thu, 09 August 2007 05:33

For example, the imp utility is on Node A, export.dmp file is on Node A and the destination database that it will be imported into is on Node B.


I think the questioner wants a different one. He wants imp utility is on node A. dump file is on node B. Import will be done from node A by accessing the dump file from node B.
Re: import [message #257820 is a reply to message #257657] Thu, 09 August 2007 04:55 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
My response was in regards to Sanka's statement:

sanka_yanka wrote on Wed, 08 August 2007 05:17
If you have oracle client installed on your remote machine then you can import the the data using the remote imp utility. for that you have to provide the username/password@tnsname on the username parameter.

Nevertheless, if the OP has the appropriate mappings configured, importing the remote dump file should still work. However, I haven't had the time to test this myself.
Previous Topic: SQL*Loader - How to get it to selectively overwrite existing records?
Next Topic: How to Replace 0?
Goto Forum:
  


Current Time: Mon Dec 09 21:21:47 CST 2024