I don't know what version of MS SQL you are using, and I don't know
what the objectives are of your data transfer. I am only familiar with
MSSQL 7.0, but there is an import data utility in SQL Server that is
capable of importing data directly from an Oracle database. It
connects directly to Oracle and you don't need to use Oracle's export
utility. It does not lend itself very well for ongoing automated
processes, but it works well for a one-time move of data from Oracle
(or any other source) into a blank MS SQL database -- and of course
your MS SQL database has to physically be able to connect to the Oracle
> I want to export oracle tables into flat file, using
> the export utility of oracle. Now i want to know the
> file- structure of the exported files. Since after this
> I want to import this flat file to Ms sql. So if any1
> knows something about this, pls tell me.
> * Sent from AltaVista http://www.altavista.com Where you can also
find related Web Pages, Images, Audios, Videos, News, and Shopping.
Smart is Beautiful
Sent via Deja.com http://www.deja.com/
Before you buy.