Hello, I need to migrate a database from postgres to Oracle

My Postgres box has this software version:
- PostgreSQL 7.4.2
- O/S: Conectiva Linux 10

My Oracle box has this software:
- Oracle 10gR1
- O/S: Windows Server 2003

I could use PgAdmin and make txt files of data for each table and then
import them to Oracle. My problem is that there is one table that
contains Blob field. How can I migrate this table to my Oracle?
I thought to use pg_dump utility, but would Oracle recognize the
output dmp?

On Mon, 13 Sep 2010 12:31:20 -0700, Big George wrote:

Use pg_dump --inserts. It will generate plain insert commands which
should be executed smoothly on the Oracle side. Oracle doesn't have the
copy command, so this is the simplest method, though not the fastest. The
fastest would be to write a SQL loader script and load the table into
Oracle RDBMS using sqlldr.



--
http://mgogala.byethost5.com