Thanks for the reply !
I tried changing this parameter but it didn't do the trick.
In my case, it was not a configuration problem. The creation script included with Jforum2 for Oracle shows columns of type BLOB and CLOB, so the Migration Toolkit converts it into "bytea". But the creation scripts for a Postgres DB indicates TEXT type column.
The data were correctly migrate, so I manualy rewrote the data with the appropriate format using this function:
credit goes to Jérôme Saboie our DBA.
After convertion, the content was displayed correctly.
Edit: In fact the conversion from Oracle DATE type (type that include hour, minute, second) to Postgres DATE type is wrong as DATE type in Postgres contains only the year, month, day. The wise way to work around this issue is to migrate the schema only (with -shemaOnly option) then update the type DATE to TIMESTAMP, and finaly migrate the data with -dataOnly option.
This message was edited 1 time. Last update was at 28 Jun 2012 03:56:14