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: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Camargo
> Sent: Friday, July 05, 2002 4:04 PM
> To: [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED]
>
>




---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly


Reply via email to