Re: Informix tables into Oracle

You can use the Sybase OmniConnect product, point it to both Oracle and Informix, then:

        select * into Oracle_table from Informix_table.

Yes, it's that simple.

The Sybase Adaptive Server developer's kit also provides you with the means of accessing a file system, and you can then treat your file system like any other data source. Ie: select * into Oracle_table from File_table

Regards,
Steve Olson
Sybase.

Jerry Gitomer wrote:

> Hi Anders,
>
> For each of the tables you want to port run the following two programs
> and put the output in the same directory:
>
> Create text files from Informix tables using unload. (End the file
> name with .dat)
> Run dbschema -d <database_name> -t <table_name> -p -ss
> <table_name>.sql
>
> Next exit the <table_name>.sql file(s). Delete the first two lines and
> you are left with a create table statement. You will find that the syntax
> for constraints is somewhat different and that you will have to edit them.
> The only other editing you will have to do is to delete or change the in
> dbspace and extent clauses. (I set up defaults for the users default
> tablespace and don't bother using them).
>
> Create the Oracle tables. The easiest way is to start up sqlplus from
> the directory containing the *.sql files you created and then run them one
> at a time using:
>
> @<table_name>
>
> Next build Oracle SQL*Loader control files for each table using the
> model and name them using the pattern <table_name>.ctl :
>
> LOAD DATA
> INFILE '<full_path_name>'
> BADFILE '<full_path_name>.bad'
> INSERT INTO TABLE <table_name>
> FIELDS TERMINATED BY '|'
> (
> user_id VARCHAR2(12),
> user_name VARCHAR2(20),
> group_name VARCHAR2(10)
> )
>
> Finally, run the SQL*Loader from the directory with the data files using
> the command:
>
> sqlldr <user>/<password> control=<table_name>
>
> regards
>
> Jerry
>
> Anders Gunnare wrote in message <361DCD74.F9D41E24_at_lule.frontec.se>...
> >Hello World,
> >
> >Which is the simpliest way to do the following:
> >
> >1) take a table from Informix
> >2) make that table exact as it was in Informix but now is it in Oracle
> >with all the values.
> >
> >Or haow do I import a textfile into an Oracle db ?
> >
> >I'm driving on a Unix.
> >
> >--
> >Best regards
> >Anders Gunnare
> >
> >
> >
> >===============================================================
> >"Impossible only means that you haven't found the solution yet"
> >===============================================================
> > Frontec Norr AB
> > Anders Gunnare
> > anders.gunnare_at_lule.frontec.se
> > Aurorum 1
> > S-977 75 Luleå
> > Sweden
> >
> > +46 (0) 920 752 09
> >===============================================================
> >
> >
> >
Received on Fri Oct 09 1998 - 00:00:00 CDT