Re: Data source for SQLLOADER

Hi there
SQLloader is for loading data from text like data files to oracle tables. If you intend to unload data from oracle to load back to oracle again you're better off with Import/Export utils.
If you need to unload data in text format, there is no such util straight away even though I know of a particular company who makes such tool. You can use sqlplus and spool facility or some people prefer to connect with MS-Access and then take a copy of table and then export it as text file. hope this helps
reza

<newbie22_at_my-deja.com> wrote in message news: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.
Received on Fri Nov 26 1999 - 16:44:30 CET