Super User is a question and answer site for computer enthusiasts and power users. 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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .