OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import [message #256635]

Mon, 06 August 2007 03:22

shanthis
Messages: 6
Registered: June 2007
Location: Chennai

Junior Member

how to import using oracle 9i dump file available at remote system?

Report message to a moderator

Re: import [message #256649 is a reply to message #256635]

Mon, 06 August 2007 04:21

Littlefoot
Messages: 21826
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.

Report message to a moderator

Re: import [message #256650 is a reply to message #256635]

Mon, 06 August 2007 04:25

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.

Report message to a moderator

Re: import [message #257388 is a reply to message #256650]

Wed, 08 August 2007 04:17

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

Report message to a moderator

Re: import [message #257397 is a reply to message #256635]

Wed, 08 August 2007 04:38

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

sanka_yanka wrote on Wed, 08 August 2007 03:17

Sanka you talking about datapump network mode ?
Network mode is new in 10g .

Report message to a moderator

Re: import [message #257564 is a reply to message #257397]

Wed, 08 August 2007 11:50

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

Report message to a moderator

Re: import [message #257579 is a reply to message #257564]

Wed, 08 August 2007 12:28

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?

Report message to a moderator

Re: import [message #257634 is a reply to message #257579]

Wed, 08 August 2007 18:33

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?

Report message to a moderator

Re: import [message #257657 is a reply to message #257634]

Wed, 08 August 2007 23:17

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.

Report message to a moderator

Re: import [message #257820 is a reply to message #257657]

Thu, 09 August 2007 04:55

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

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.

Report message to a moderator

Previous Topic:	SQL*Loader - How to get it to selectively overwrite existing records?
Next Topic:	How to Replace 0?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 03 18:42:51 CDT 2026