-
Migration - Need ur Views
Hi,
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
Thanks
Arshad
[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
Anuj Pathak
New Delhi
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.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Hi,
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|