Search code examples
oracle-databasedatapump

Find tablespaces used within datapump dump file

Given an Oracle datapump file is it possible to find/retrieve the used tablespaces without accessing the original/source schema?

I tried to use the strings Linux command but I'm unable to find pattern indicating a tablespace.

Any idea?

Solution

  • You can use sqlfile option to dump DDL statements to a file.

    impdp directory=expdir dumpfile=myexp.dmp sqlfile=myddl.sql