Migration - Need ur Views
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
[Edited by jarshad on 03-03-2001 at 04:43 AM]
Convert data into flat files and use SQL LODER to import the flat files into Oracle
6216666 ext 207
I think that it is also possible through the oracle migration work bench. I'm not sure exactly, b'cos I haven't used it so far.
Life is a journey, not a destination!
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.
Best regards, Dmitry.
Click Here to Expand Forum to Full Width