Determining schemas inside an Oracle data pump/dump file

Have you ever wondered how you can findout the schema or tablespace names contained within an Oracle Datapump dump or export?

Well, there is a way and it's an easy one:

First make sure ORACLE_SID and ORACLE_HOME is corectly set and Oracle binaries are in your PATH. Then using a user with appropriate privillages execute :

impdp \'/ as sysdba\' dumpfile=<YOUR_DMP_FILENAME>.dmp sqlfile=<OUTPUT_FILENAME>.txt

After this is done, simply open the text file for viewing and look for statements like :
CREATE USER ......

No comments:

Post a Comment