Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL data -> Oracle

PostgreSQL data -> Oracle

From
leonardo.camargo@eds.com (Leonardo Camargo)
Date:
Hi,

How can i migrate the data from a PostgreSQL db to an Oracle database ?

Any tip, advice, article, howto would be helpful.

thnx in adv.

Ka

Re: PostgreSQL data -> Oracle

From
Bruce Momjian
Date:
Leonardo Camargo wrote:
> Hi,
>
> How can i migrate the data from a PostgreSQL db to an Oracle database ?
>
> Any tip, advice, article, howto would be helpful.

Wow, this is getting to be an FAQ.  See contrib/oracle and for tips, see
the techdocs.postgresql.org site.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: PostgreSQL data -> Oracle

From
"Nick Fankhauser"
Date:
Back in the days when I used Oracle, there was something called SQL*Loader
that allowed you to read a flat ASCII file into an Oracle table.

If I were doing this, I think I'd do a pg_dump of the data, filter the dump
file to remove the "copy" commands & then use SQL*Loader or it's newer
equivalent on the dump file.

Of course we're all just aghast that you'd want to do such a thing... <g>

-Nick



> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Leonardo Camargo
> Sent: Friday, July 05, 2002 4:04 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] PostgreSQL data -> Oracle
>
>
> Hi,
>
> How can i migrate the data from a PostgreSQL db to an Oracle database ?
>
> Any tip, advice, article, howto would be helpful.
>
> thnx in adv.
>
> Ka
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>

TEST, ignore this, plz

From
Auri Mason
Date:
test