Home » RDBMS Server » Server Utilities » Recovery Problem
Recovery Problem [message #459911] Wed, 09 June 2010 00:24 Go to next message
Messages: 2
Registered: June 2010
Junior Member

I have a full oracle back-up. This back-up is taken from a database which is installed on drive D:\. But i want to use this back-up to recover a database on drive C:\. When i try the windows command prompt "imp user/password@listener filename FULL=Y" command, i get errors that te tablespaces and uses cannot be created since the drive letter is different.

How can i solve this problem?

Re: Recovery Problem [message #459919 is a reply to message #459911] Wed, 09 June 2010 00:44 Go to previous message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
export is NOT a backup so you cannot make recovery with import.
If you use a REAL you could do it.
With export dump you can't, you have to create your tablespaces yourself outside import.


[Updated on: Wed, 09 June 2010 00:47]

Report message to a moderator

Previous Topic: Load Comma Delimited file having multiple datasets into multiple tables using a single CTL file (mer
Next Topic: DBMS_DATAPUMP.metadata_filter + long table list
Goto Forum:

Current Time: Fri Sep 17 07:19:24 CDT 2021