Re: oracle export utility ?????

Hi Andy,

To quote from Oracle docs:

Export extracts the object definitions and table data from an Oracle database and stores them in an Oracle binary-format

endquote

It's intended to provide a way to move stuff between Oracle databases, etc.

The easiest way might be to write a script to extract the fileds and make a comma-separated file or something simple that MS/SQL (server?) might understand for import purposes.

Hope this helps a little.

john

andy wrote:

> hi,
>
> 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.
>
> seeya,
> andy
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Sun Feb 13 2000 - 13:28:24 CST