Find tablespaces used within datapump dump file
datapump, oracle
Solution
You can use sqlfile option to dump DDL statements to a file.
impdp directory=expdir dumpfile=myexp.dmp sqlfile=myddl.sql
Problem
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?