Re: Help Getting Data out of Oracle and into a file

sg_at_skynet2.skynet.att.com wrote:
>
> I want to transfer some of an existing Oracle database into
> a new NT SQL server 6.5 database. It occurred to me that the
> best way to do it is to write out the relevant fields into a
> a text file, then read that into the SQL Server.
> Can anyone give me any hints on how to go about it?

Using SQL Plus, simply spool to a file, set headings etc off, and perform the select you need. You can end up with a comma or whatever delimited file through the select statement you construct.

Cheers
Chris Received on Sun Oct 13 1996 - 00:00:00 CEST