POSTGRES to ORACLE dump

You might want to consider pg_dump with the --column-inserts option.
[quote from man ]
...
--column-inserts, --attribute-inserts
Dump data as INSERT commands with explicit column names
(INSERT INTO table (column, ...) VALUES ...). This will make
restoration very slow; it is mainly useful for making
dumps that can be loaded into non-PostgreSQL databases.
However, since this option generates a separate command for each row,
an error in reloading a row causes only that row
to be lost rather than the entire table contents.

[quote ends]

On Tue, Mar 3, 2015 at 3:59 AM, Oliver Dizon
<johnoliver@rtzassociates.com> wrote:

Hello,

Is there a way to create a dump file of a Postgres DB to Oracle DB?

I've found some ways using general snippets but I would like to know what is the best way to do it.

Thanks

Regards,
______________________
Oliver G. Dizon
Z Getcare Systems Team
RTZ Associates, Inc.
johnoliver@rtzassociates.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general