Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a full Oracle dump, I know I have to imp the dump with the fromuser touser clause.

However, I don't know the names of the schemas included in the dump. How can I open the dump created with Oracle 10g just to check and analyze the content?

share|improve this question

Use the SHOW=Y option for imp

From the manual at

When SHOW=y, the contents of the export dump file are listed to the display and not imported. The SQL statements contained in the export are displayed in the order in which Import will execute them. The SHOW parameter can be used only with the FULL=y, FROMUSER, TOUSER, or TABLES parameter.

share|improve this answer

Worth noting is that oracle dump files are a stream format with snippets of SQL embedded. You can also use sed to do substitutions on it, such as schema names.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.