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

Report message to a moderator

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: 10708
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.

Report message to a moderator

Previous Topic: Recover Packages/Procedures that were deleted
Next Topic: RMAN-is it hanging?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 17 20:41:55 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.