In part of triggers and Tables it has 2 important thing schema+data
if Oracle can unload data to text file then you finish 50% . Schema you can use Power Designer to reverse engineer to grap schema .
In part of store procedure you can use power designer too
What dananio wanted to say is that you 'll need an ASCII dump of your database.
Is it possible to recreate the database schema from Oracle in your informix database?
In many cases, the application provides a tool to do these dumps. ERP systems like SAP is able to do it.
Anyway. if you don't want to use the ASCII dump:
Oracvle -> File
File -> Informix
you can use the Enterprise Gateway Manager from Infromix. This tool can connect to an Oracle database from an infromix database.
DBMS ---<text>------> data
DBMS ---<sql table>--> schema
If you can combine 2 things it's independ from DBMS
it will have a litle problems with sql-table if you transform to SQL-standard everything will OK