Answered Oracle to Progress/OE

[casorohi]

Hi friends
One of our client wants to migrate the Oracle 9i and 10g Databases to OE10 on Linux 64 BIT. Want know is there any guide lines, document, Progress KB article on this. or any one experienced migrating the Oracle DB to Progress DB. The DB size is around 150GB.

Thanks

 

[cj_brandt]

we did this a year or 2 back on an AIX system - OE was 10.2B and Oracle was 10g. There was only 1 database about 50gb to migrate so we did everything manually.
converted the schema to Progress - about 150 tables.
dumped the tables to CSV file and then loaded using the bulk loader.
built the indexes - the application wasn't on 10.2B06 yet, but we installed it to a separate DLC to get the faster index rebuild times.
generated the table stats.