Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.