Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

getting user/schema details from export dumps

saikat89banerjeeApr 13 2014 — edited Apr 13 2014

Recently in one issue a schema was dropped in production. Now, we have had datapump backup, we could have imported the the schema from latest backup without creating the user explicitly, because datapump creates the user also. But we had traditional export. So, before importing we needed to create the use with assigning proper default tablespace. But the schema is already dropped, so we don't have relevant information to create the user, Is there any  way to get such info from existing export dump,so that the schema can be created properly before starting export?

Thanks,

Saikat

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2014
Added on Apr 13 2014
1 comment
146 views