Re: Help! - Transfer tables from Oracle into Postgresql

can't you download into Access, and then upload into postgres?? Now, I don't really know how to UPLOAD, but it seems an idea...

Andreas Stellmach wrote:
>
> -----------------------------------------------------------------------
> Info:
> Oracle 8i (8.1.7) on Linux RedHat 6.2
> PostgreSQL 7.1 build with UNICODES support on Linux RedHat 6.2
>
> Oracle ODBC driver version 8.01.73.00
> Microsoft ODBC driver for Oracle version 2.573.7326.00
> Postgres SQL ODBC+ driver version 1.0
> MS MDAC 2.6
> --------------------------------------------------------------------------
>
> I need to transfer 170 tables (ca. 8GB) from Oracle 8i into PostgreSQL. I
> try use the latest version of "pgAdmin", but I get a message from from
> Oracle, "default username feature not supported" (ORA-01004). I try a
> different ODBC drivers, but it didn't help.
> I did try the newest Microsoft DTS utility, and I can connect to Oracle and
> can create the tables in PostgreSQL, but it can't insert the data from
> Oracle.
> I know, that I could export the tables from Oracle in SQL scripts (f.e.
> using TODD), modify them and insert into PG using psql, but it's a lot of
> work and I hope it's easier solution for it.
>
> Any advice welcome.
>
> Thank you,
> A.S.
Received on Fri Aug 10 2001 - 15:44:51 CEST