Re: export utility of oracle ?????

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Mon, 14 Feb 2000 00:19:32 -0500
Message-ID: <38A79064.36FB2106@erols.com>

andy wrote:
>
> hi,
> I want to export oracle table files into flat files,
> and then import them into MS sql. For this i need to
> know the way export utility stores the flat file?
> I mean , i need info about the file-structure ??
> If anybody can help, 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

        Export is not the tool you should be using. Instead try the following:

• kill the headers SET PAGES 0
• change the column separator SET COLSEP "," (you may have to surround this with single quotes) SPOOL <flat_file_name>.txt SELECT * FROM <table_name.; SPOOL OFF

The spool file will be ready to load.

--
Jerry Gitomer
Once I learned how to spell DBA, I became one. Received on Sun Feb 13 2000 - 23:19:32 CST