I have a typycal problem of migrating around 200 tables, views and stored procedures from DB2/400 to Oracle(8i). since Data volume is high I can'nt go for the normal approches. Looking for your suggestions for this.
Flat file approch I need to manualy create a views & procedures. Is there any other way apart from this
Try a migration tool at [url]http://www.ispirer.com/chyfo.html[/url]
It provides you the fastest, the easiest and the most powerful way to migrate your database into Oracle.
It allows you to extract any data from any database. It works in conjunction with Oracle SQL Loader.
The tool creates text files (moving of LOBs are fully supported), generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files for SQL Loader.
The tool has a lot of other features.