We just did one to 9i.
Use the High performance loader in Informix to unload the data. And then
import the data into oracle.
To convert the schema you can use a tool like Erwin or use the dbschema
utility in Informix and manually change the schema.
Oracle takes a lot more work than Informix so be prepared to have to spend
more time for DB management.
-----Original Message-----
From: Ezekiel Filane
[mailto:oracledba-ezmlmshield-x67548177.[Email address protected]
Sent: Monday, January 30, 2006 8:09 AM
To: LazyDBA Discussion
Subject: Migrating from Informix 7 DW to Oracle 10g?
Hi There.
- Anyone who can provide me with step by step migration from Informix 7
to Oracle 10g
- Mybe a link to that or full documentation.
- Or if you have done this please share your experiences.
Thanks
Ezekiel
----------------------------------------------------------------------------
----
Please note: This e-mail and its contents are subject to a disclaimer
which can be viewed at http://www.woolworths.co.za/disclaimer. Should
you be unable to access the link please e-mail [Email address protected]
and a copy of the disclaimer will be e-mailed to you.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page