dbi: Pg and Oracle 9i

Howdy:

At the risk of sounding silly, does anyone know
of a way to export data from PostgreSQL to
Oracle via perl featuring DBI?

Background:

I'm running PostgreSQL 7.2.1 on RedHat Linux 7.2
and I have Oracle 9i on the same box.  PostgreSQL
is dying and the tool to dump the data (pg_dump)
no longer works (actually, it's due to a severe
problem with the PostgreSQL database ...) and
the best shot I have now are a few items:

* use MS Access to migrate (shoot me now!)
* use Perl
* use copy on PostgreSQL and sqlldr for Oracle
(and then figure out how to automatically make
schema/ table DDL for all 1500 tables)

All of the options above have issues, however, I figured
that using Perl (DBI) would be better because I
could open up a connection between both databases
at the same time and just pipe the information
from one to the other.

For that to happen, I need to figure out how to
keep the data (from Pg) and open a new session 
with Oracle and I don't know how to do that.  I 
can open up one or the other database and put 
data into a file ...

Unless there is a conversion / migration tool that I
don't know of, can someone point me to an example of
directly moving data from one database to another
via DBI?

Thanks!

-X

• dbi: Pg and Oracle 9i by Johnson, Shaunn
• Re: Pg and Oracle 9i by Pavle Lukic