CODEWITHSUNDEEP
oracle-databaseoracle10gdmp
Pushpendra Kuntal
Pushpendra Kuntal

Reputation: 6186

How to open .dmp oracle backup file

I have a backup.dmp file, which is backup file of my database built in oracle. please suggest me how can I see tables, schema etc stored in that backup.dmp ? should I install some software to open this backup.dmp file. Thank you in advance.

Upvotes: 1

Views: 14827

Answers (2)

mmmmmpie
mmmmmpie

Reputation: 3029

You can view the dump file contents using Toad (must be fully licensed with the DBA extension), imp or impdp. 

impdp scott/tiger@orcl directorory=dpump sqlfile-abc.sql dumpfile=xyz.dmp and logfile=xyz_log.log full=y

Or

imp scott/tiger@orcl file=abc.dmp show=y log=abc_log.log full=y

These commands will create viewable DDL of the actual DB creation.

Upvotes: 1

eliatou
eliatou

Reputation: 744

.dmp files have been generated by oracle tools (data pump or maybe export). To exploit this files, you need to install Oracle (try for exemple oracle 10g express) and then use the import(imp) or data pump (impdb)

Upvotes: 1

Related Questions