I have an Oracle dump file which I need to import but do not know what is its tablespace name. How can I get it from the dump file? I know that it is possible to get many information using impdp MASTER_ONLY flag but can't see there any information about dump's tablespace.

1 Answer 1



impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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