Home » RDBMS Server » Server Utilities » Exp\Imp from one pc to another pc (Oracle 9i , Win XP)
icon5.gif  Exp\Imp from one pc to another pc [message #302168] Sun, 24 February 2008 07:47 Go to next message
adilsami
Messages: 46
Registered: October 2007
Member
Hi there, Smile

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.
Re: Exp\Imp from one pc to another pc [message #302169 is a reply to message #302168] Sun, 24 February 2008 07:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/faqiexp.htm
Re: Exp\Imp from one pc to another pc [message #302170 is a reply to message #302169] Sun, 24 February 2008 07:56 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: How to load mutiple Variable length flat files into multiple tables
Next Topic: SQL Loader Problem
Goto Forum:
  


Current Time: Sat Dec 10 09:22:36 CST 2016

Total time taken to generate the page: 0.13646 seconds