I AM USING THE INFORMIX SE ON SUSE LINUX7.3 .

PRESENTLY I AM HAVING DATA IN ORACLE DATABASE SERVER INSTALLED ON THE WINDOWS NT SYSTEM.

I WANTED TO IMPORT THE WHOLE DATABASE FROM ORACLE TO INFORMIX .

PLEASE ANY ONE KNOWS ,HELP ME

THANKS IN ADVANCE
SANJEEVMPATIL

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

can u tell me the steps required to do the same


tahnks
sanjeev

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.

Right ,
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