Re: Is it possible to export a table to a txt-file??

Corrected link is
http://asktom.oracle.com/~tkyte/flat/index.html

Your code is incorrect.
You should fire up sqlplus and issue
[Quoted] [Quoted] set heading off feedback off pagesize 0 newpage 0 spool <any filename>
select ...
from ...
etc.

Hth,

Sybrand Bakker, Oracle DBA
The usual adminition to read manuals applies.

"Øyvind Skjold" <o-skjold_at_online.no> wrote in message news:ItrQ6.2051$lM3.44540_at_news1.oke.nextra.no...
> Ok,
>
> thanks!!
>
> But how do I write a sql-select to a file?
> Something like this:
>
> <SQL> select A,B,C.... from TABLE > file
>
> By the way, the link to Tom Kyte's website didn't work..
>
> Øyvind
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:th4g3of7qb0pd3_at_beta-news.demon.nl...
> >
> > "Øyvind Skjold" <o-skjold_at_online.no> wrote in message
> > news:dIqQ6.2031$lM3.44341_at_news1.oke.nextra.no...
> > > Hey,
> > >
> > > I've a problem saving tables through ODBC - ACCESS. The files get so
> > > incredible huge..
> > > So I'm wondering if it's possible to export directly to a
 txt-compatible
> > > file..( with predefined fieldlength )?? Or isn't it possible??
> > >
> > > I'm pretty new i the game, so you have excuse me if it's a silly
 question
> > > :-)
> > >
> > > Øyvind.
> > >
> > >
> > >
> > >
> >
> > You have several options
> > 1 download the flat file utility from Tom Kyte's website
> > (http:///osi.oracle.com/~tkyte)
> > 2 Use Toad for this purpose if you already have it
> > 3 Write your own select
> >
> > I do not however believe the size of the file is really going to change.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> >
> >
>
>
Received on Sat Jul 21 2001 - 23:45:03 CEST