Forum Stats

  • 3,757,061 Users
  • 2,251,192 Discussions
  • 7,869,716 Comments

Discussions

getting user/schema details from export dumps

saikat89banerjee
saikat89banerjee Member Posts: 1
edited Apr 13, 2014 8:30AM in General Database Discussions

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

Tagged:

Answers

This discussion has been closed.