Unanswered: Migrate blob field from Postgres to Oracle
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 was thinking to use pg_dump utility, but would Oracle recognize the output dmp?