I need help to transfer data from postgreql to oracle database on
The original productin application runs on oracle.
We need this setup temporarily for certain time period till we are
confortable that our application can survive on postgresql.
Please help if somebody has worked on such projects.
I tried taking pg_dump as follows from postgresql 7.4.5
pg_dump -t tablename_test -a -D -O rpt_production > tablename_test.sql
and than ran below on oracle but i got many errors.
One reason i can think of is becase i have column names like
"version", "type", in the insert command?.
Am i misssing any thing
pgsql-admin by date
|Next:||From: David A. Leedom||Date: 2005-05-05 12:46:31|
|Subject: Re: Need help in data migration|
|Previous:||From: Greg Sabino Mullane||Date: 2005-05-04 23:44:18|
|Subject: Re: [ANNOUNCE] IMPORTANT: two new PostgreSQL security problems found|