OraFAQ Forum: Server Utilities » Exp\Imp from one pc to another pc

Home » RDBMS Server » Server Utilities » Exp\Imp from one pc to another pc (Oracle 9i , Win XP)

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

Exp\Imp from one pc to another pc [message #302168]

Sun, 24 February 2008 07:47

adilsami
Messages: 46
Registered: October 2007

Member

Hi there,

I want to export a certain USER with its tables & data ,
and import it to another PC , both having the same versions
of Oracle database .

can someone please tell me the steps for both exp\imp ?

Regards,
Adil.

Report message to a moderator

Re: Exp\Imp from one pc to another pc [message #302169 is a reply to message #302168]

Sun, 24 February 2008 07:55

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/faqiexp.htm

Report message to a moderator

Re: Exp\Imp from one pc to another pc [message #302170 is a reply to message #302169]

Sun, 24 February 2008 07:56

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use tns entries to do the import over network.
Something like
#local machine
exp user/pass
# use proper tnsentries to identify other database
imp user/pass@otherdatbase_in_remote_machine

or
Just ftp the file to remote machine with bin option
and
proceed with import.

Report message to a moderator

Previous Topic:	How to load mutiple Variable length flat files into multiple tables
Next Topic:	SQL Loader Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 05:29:45 CDT 2024