Find tablespaces used within datapump dump file

oracle datapump
Andrea de Palo picture Andrea de Palo · Oct 29, 2012 · Viewed 15.5k times · Source

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?

Answer

Rob van Laarhoven picture Rob van Laarhoven · Oct 29, 2012

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

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

Related questions

Why do I get ORA-39001: invalid argument value when I try to impdp in Oracle 12c?

When I run this command in Oracle 12c SE2: impdp system/Oracle_1@pdborcl directory=DATA_PUMP_DIR dumpfile=mydb.dmp nologfile=Y I get this: ORA-39001 : invalid argument value ORA-39000 : bad dump file specification ORA-39088 : directory name DATA_PUMP_DIR …

Read More
oracle data pump import ORA-39002 with ORA-39070, ORA-29283 and others on Windows 10

I am using data pump to perform an import on 4 .dmp files and keep on receiving the set of errors as below: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_…

Read More
How to exclude certain tables from Oracle datapump export

I have a large number of user schemas in my Oracle database. I wish to export the table data for these schemas but exclude any tables that are named with the second character an underscore. For example I wish to …

Read More