data transfer from oracle 9i to oracle 10g

[lovekang]

I have to transfer data from oracle 9i to oracle 10g.

objects, for examples tables, there are differences between the old schema in 9i and the new schema in 10g,
some tables are divided, and some are merged.
as you might guess, making scripts are very cumbersome jobs.

I need tools or utilities which have the feature of generating scripts with visual gui.

any ideas?

Thanks.

 

[jimirvine]

Oracle Warehouse Builder
Or
Oracle Data Integrator
Or
Business Objects Data Integrator

 

[commatom]

Checkout Wherescape RED.
Especially if this is a Data Warehouse project.

 

[lovekang]

Thanks.
Let me check.