Re: Data source for SQLLOADER

Leo Van Nieuwenhuyse wrote:
>
> have a look at http://govt.oracle.com/~tkyte/flat/index.html there's a kind
> of unloader in it;
>
> <newbie22_at_my-deja.com> schreef in berichtnieuws
> 81m7jd$eit$1_at_nnrp1.deja.com...
> > HI all,
> >
> > I'm familiar with importing data with SQLLOADER.
> >
> > But now I'm wondering,
> > where does the source data come from?
> >
> > I can't find any SQLLOADER commands to unload the
> > data from tables. Can SQLLOADER unload the data?
> >
> > Which Oracle utility/command would unload the data to a
> > Unix flat file?
> >
> > Cheers,
> >
> > Argosy
> >
> >
> >
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

You cannot do it from SQLLOADER. You must use a sqlplus statement whose result you write on a system file
es:

set heading off
set pagesize 0
set linesize 80
spool catalog
select * from cat;
spool off

you obtain a file called "catalog.lst"

hi
Massimo Received on Sat Nov 27 1999 - 15:57:09 CST