Online migration from Oracle to Postgresql

Currently we run Oracle on a Mac OS X server (now old hardware), but it seems oracle have forgotten us, we can not upgrade . So we listen on EnterpriseDB (enterprise support for postgresql). And i would like to test our app and the migration process.

The online migration tool seems very promising but i get this error
ERROR: invalid byte sequence for encoding "UTF8": 0x8e
I get lots of then, with different codes.

The Oracle database is 10g release 2. Using UTF-8 as the encoding, this is why i found strange this error all is UTF-8.

Also I would appreciate any hint for finding docs about the online migration tool becouse i only found a brief tutorial.

Thanks.

It's encoding problem. Oracle is using UTF8 and probably you may have not choosen UTF8 while installing PPAS. Install PPAS using UTF8 and your migration problem gets resolved.

Thanks & Regards,
Prashanth Ranjalkar
EnterpriseDB

I used the default database, edb, created by the installer.

Postgres studio report that this database it's encoded in UTF-8.

Any hint?