Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 423
Andrea de Palo Avatar asked Oct 29 '12 07:10

Andrea de Palo


1 Answers

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

impdp directory=expdir dumpfile=myexp.dmp sqlfile=myddl.sql
like image 135
Rob van Laarhoven Avatar answered Nov 02 '22 02:11

Rob van Laarhoven