Postgresql – way to dump an Oracle db as SQL statements, à la pg_dump

oraclepostgresql

I'm very new to Oracle. It looks like all the Oracle DBA use binary only dumps. This sometimes cause problems, and seems rather useless to me (performance gain is bound to be negligible), but what do I know.

  1. Is there a good reason that escapes me?

  2. Is there a tool like pg_dump for Postgres that can generate SQL statements from a database?

One of the application could be moving from one version to another, or converting the data to another DB.

Best Answer

I am not aware of any tool provided by Oracle that does what you ask. While I have in the past used DbVisualizer to export smaller tables/schemas from oracle (DDL and and insert statements) it isn't quite the same as pg_dump.

However, if you are planing on "converting the data to another DB" where the other DB is postgres then take a look at ora2pg.

Related Topic