Re: Ingres tables -> Oracle tables?

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). Received on Tue Mar 04 1997 - 00:00:00 CET