Re: PostgreSQL data -> Oracle

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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Leonardo Camargo
> Sent: Friday, July 05, 2002 4:04 PM
> To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org
>
>