Convert a .dmp Database (made with EXP) to an unique .sql file (with Oracle 12.2.0)

Question

I need to convert a .dmp database file to an unique .sql file. I have installed Oracle 12.2.0. I am using Windows 10.

How can i do it?

Thank you so much

Answer 1

Be it a datapump dump or a dump exported with conventional export: both tools create files in a proprietary format, and you can't convert them to text.

Why would you want to do that? If you want to recreate the schema with all the data in it just import the dump with impdp (datapump) or imp (conventional) and you have the schema.

If you want to know a certain structure of an object (e.g. a view) you could import only that object.

just run impdp help=Y (datapump) or imp help=Y (conventional) to see how to do that.

If you really want a readable file of your database then have a look at Oracle SQL*Developer which supports unloading tables into insert statements and the like and exporting DDL Statements of certain objects into text format.

cheers