Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

We are having oracle 11g schema + data dump. As this dump is vary large, I would like to extract only part of schema with data. will this possible to achieve ?

Thank you

share|improve this question
Is it a simple SQL file? If yes, grep comes to mind. – Bobby Jan 27 '11 at 8:29

If you're taking about the dump generated using exp/expdp tools - then probably* no

*There is a tool called NXTract but I'm skeptical about it and haven't tried it.

share|improve this answer

IMPDP does have some options. Firstly you can choose to only import specific schemas (which is useful if you've done a full database export)

Secondly you can choose to INCLUDE or EXCLUDE specific objects or objects where the name matches a particular format.

Thirdly there is a QUERY parameter that "Allows you to specify a query clause that filters the data that gets imported."

If you are using the older EXP/IMP utilities, then you miss out on that flexibility

share|improve this answer

IMP also has some flexibility. If you know what schema(s)/table(s) you want to import, then use the TABLES keyword to specify them.

Without knowing exactly what produced your "dump", it's a bit difficult to provide definitive answers. Also, do you want certain tables restored, or just parts of certain tables?

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.