Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Informix to Oracle conversion
We converted in the other direction, and there were a couple of gotchas:
- Using flat files, you must ensure that there are no carriage returns in
your data, as
well as no occurrences of "|" or whatever delimiter you are going to use.
- Informix has no "sequences", and deals with triggers by always calling
stored procedures.
For the second point, we had to code up fake tables to mimic a sequence,
that was
accessed sequentially by the different sessions needing unique numbers.
This is in fact
pointing out features of Oracle that could be useful to you in your
conversion, but that
is probably at a later stage.
Akshay Jain
-----Original Message-----
From: James Howerton [mailto:jhowerton_at_uabmc.edu]
Sent: Monday, September 18, 2000 6:16 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Informix to Oracle conversion
Thanks to everyone who gave me some advise on Informix to Oracle conversion. I'm rolling now, still some errors but I'm making progress.
...JIM...
>>> sfcawley_at_interaccess.com 9/16/00 2:15:23 AM >>>
You can get all of the Informix docs from: http://www.informix.com/answers
Dbacces is Informix's SQL*Plus. It has a menuing system with it. I would connect and run all scripts as informix (same as sys or system).
SC
> Bill,
>
> The help I need is not really with the kit but with just a few Informix
basics. I have never worked with Informix and there is nolonger anyone here
that has either(or won't admit to it anyway). The scripts supplied by the
Oracle kit use dbadmin to interface with the database. I have no clue how to
use this product and I'm running it against a production system. Do I need
to logon as the Informix UNIX user and then run dbadmin? When I run it as
annother user I get not connected errors, here is an example of the run
>
> " dbaccess database_name script.sql"
>
> Is there anything resembling sqlplus available for interacting with the
database?
>
> Thanks
>
> ...JIM...
>
> >>> wcarle_at_att.com 9/12/00 12:34:13 PM >>>
> I have done an Informix to Oracle conversion, but I'm not sure what the
> Oracle conversion kit is. I wrote my own conversion.
>
> Bill Carle
> AT&T
> Database Administrator
> 816-995-3922
> wcarle_at_att.com
>
> -----Original Message-----
> Sent: Monday, September 11, 2000 4:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Informix to Oracle conversion
>
> DBA's
>
> Has anyone done an Informix to Oracle conversion? I need a little help to
> get started with the Oracle conversion kit. Please contact me off list.
>
> Thanks
>
> Jim Howerton
> jhowerton_at_uabmc.edu
>
> --
> Author: James Howerton
> INET: jhowerton_at_uabmc.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Carle, William T (Bill), NBSO
> INET: wcarle_at_att.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: James Howerton
> INET: jhowerton_at_uabmc.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Author: Stephen F. Cawley INET: sfcawley_at_interaccess.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: James Howerton INET: jhowerton_at_uabmc.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Sep 22 2000 - 14:49:53 CDT
![]() |
![]() |