Re: PostgreSQL data -> Oracle - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: PostgreSQL data -> Oracle
Date
Msg-id NEBBLAAHGLEEPCGOBHDGIEIHFEAA.nickf@ontko.com
Whole thread Raw
In response to PostgreSQL data -> Oracle  (leonardo.camargo@eds.com (Leonardo Camargo))
Responses TEST, ignore this, plz  (Auri Mason <amason@syntrex.com>)
List pgsql-admin
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
>
>




pgsql-admin by date:

Previous
From: "Chad R. Larson"
Date:
Subject: Re: help
Next
From: Tim Ellis
Date:
Subject: tedia2sql 0.86 Released