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?
You can use sqlfile option to dump DDL statements to a file.
impdp directory=expdir dumpfile=myexp.dmp sqlfile=myddl.sql
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With