<hi****@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
how do you move very large amounts of data from db2 to oracle?
Is backup and restore possible? What are the other methods practiced?
Thanks!
You can export the data in delimited format.
Export the DDL with db2look and then make any necessary changes for Oracle
syntax. Another possibility is to import the DDL into a design tool like
Erwin or PowerDesigner and then change the database to Oracle, and then
create the Oracle DDL.