Home » RDBMS Server » Backup & Recovery » How to recover a database from an export file??
How to recover a database from an export file?? [message #145451] Thu, 03 November 2005 04:08 Go to next message
StefanTA650
Messages: 9
Registered: May 2005
Junior Member
Okay, the topic may sound a bit silly... But see the problem.
I have an oracle-export fie (created with the full=yes optin) and i want to import the data into a blank new oracle-instance. But the imp-command fails due to missing oracle users. I thought the oracle users will be restored from the dump-file... Am I wrong??

Regards, Stefan
Re: How to recover a database from an export file?? [message #145477 is a reply to message #145451] Thu, 03 November 2005 07:00 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Users will be re-created. Provided the database has the same tablespaces precreated.
So, first create the tablespaces.
then do import.
Previous Topic: Recover Packages/Procedures that were deleted
Next Topic: RMAN-is it hanging?
Goto Forum:
  


Current Time: Fri Mar 29 06:37:32 CDT 2024