|
Dave, You should be able to get the Oracle creation scripts and convert them to DB2 relatively painlessly. Oracle is more flexible than DB2 and most Oracle databases do not used fixed length numeric values. What help do you have on the Oracle side? If you sit down at a PC with access to both systems you should be able to run Toad and Operations Navigator to pull scripts from Toad and then use Ops Nav to rebuild your files. Once you have the files re-created, I would use a Java program to copy the data using a select and insert loop for each file. David Morris >>> David.X.Kahn@gsk.com 10/22/01 09:07AM >>> We have a large legacy Oracle database (40 GB) that we would like to import into DB2/400. What are our sensible options for creating a DB2 version of this database retaining as far as possible the data management information such as field names and attributes? If we could at the same time create access paths based on those in the Oracle database that would be a bonus. This is a one time load - it does not have to be kept current. Dave...
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
