Home » RDBMS Server » Backup & Recovery » Restore Oracle database
Restore Oracle database [message #7469] Mon, 16 June 2003 18:14 Go to next message
Mike Sewell
Messages: 16
Registered: April 2002
Junior Member
Greetings,

First off, I know very little about managing Oracle databases, so please bear with me.

I need to restore a database with a database export (.dmp) file from a different server. The server it's going to is Win2K, with Oracle 8.1.7.

How would I go about doing this? I've looked through the documentation I have, but have been unable to find anything.

Thanks very much in advance,

Mike
Re: Restore Oracle database [message #7470 is a reply to message #7469] Mon, 16 June 2003 19:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are both servers ( target and source ) of the same version?
if they are different use the lower version of exp to export the source and
use the same lower version of imp to import into target.
-- to export 
exp username/password@source other_options 

-- to import
-- first create the tablespaces in target 
-- with the same name as in source
imp username/password@target other_options

Re: Restore Oracle database [message #7489 is a reply to message #7470] Tue, 17 June 2003 11:00 Go to previous messageGo to next message
Mike Sewell
Messages: 16
Registered: April 2002
Junior Member
Mahesh,

Thanks very much for the help. Would I do this in SQL Plus? Also, where in the command does it mention the .DMP file to import.

Sorry to be so ingorant with Oracle, but as I said, it is all pretty new to me.

Thanks again,

Mike
Re: Restore Oracle database [message #7493 is a reply to message #7489] Tue, 17 June 2003 14:09 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
u have to call it from the command line
Not from the sqlplus.
imp help=y gives the options available.
Previous Topic: Rman
Next Topic: Backup help.
Goto Forum:
  


Current Time: Thu Nov 21 14:33:33 CST 2024