How to identify the Tablespace names from an EXPDP file

If you have been given a datapump dump file to import you may not have been given the export log file or a list of schemasĀ and tablespaces contained in that file. Fortunately all is not lost, datapump provides an option to create a text-based file containing the SQL DDL statements used to import the file without actually executing them. The […]