Re: Ingres tables -> Oracle tables?

ORACLE has available a toolkit to help convert from INGRES to ORACLE. I have not used the kit myself but am aware that there is "stuff" that you have to do by hand to complete the mirgration. Check with your ORACLE rep to get more info as I'm sure they would like to assist you in moving from INGRES to ORACLE (yuck!).

>
> Ian Britten wrote:
> >
> > Hi,
> > Does anyone know of a quick way to get a bunch on Ingres tables (ver 6.4)
> > into Oracle (ver 7.1.6)? I only have to do this once or twice, and I'm
> > hoping not to have to write a bunch of SLFLoader stuff if possible.
> > Maybe there's a utility around to do this?
> > Thanks,
> > Ian
> > ------------------------------------------------------------------------
> > | Ian Britten - Senior Analyst, britten_at_caris.universal.ca |
> > | Universal Systems Ltd., Fredericton, N.B., Canada |
> > | http://www.universal.ca, Ph (506) 458-8533, Fax (506) 459-3849 |
> > | #include <disclaimer.h> #include <quote.h> #include <asciiart.h> |
> > | Sending unsolicited, commercial junk mail to me is confirmation that |
> > | you wish to receive several very large core files from me in return. |
> > ------------------------------------------------------------------------
>
> Export from Ingres and use SQL-Loader OR export ODBC (if Ingres supports
> it) and reimport ODBC on the Oracle Instance. You'll probably still
> need to create the tablespaces and tables (structure) by hand (unless
> you have q sql program that created them originally, you may be able to
> rework that if you have it).
>

--
TEXAS NATURAL RESOURCE CONSERVATION COMMISSION
CHARLIE LANCASTER Mail Code 197
P O BOX 13087 AUSTIN, TX 78711-3087
Phone:512-239-0795 FAX:512-239-0888 e-mail:clancast_at_tnrcc.state.tx.us