Re: how to test unload to a directory defined in DB

From: Dave <x_at_x.com>
Date: Thu, 25 Aug 2005 20:37:30 GMT
Message-ID: <e_pPe.96287$G8.79589@text.news.blueyonder.co.uk>

"NormaJean S via DBMonster.com" <forum_at_DBMonster.com> wrote in message news:53625F185E0B4_at_DBMonster.com...
> hi,
> I have a directory defined in the DB with what i believe to be all the
> proper
> permissions at the unix level that the directory in the DB points to.
>
> however, i have users complaining that their application can't write to
> the
> directory.
>
> i would like to test an unload to the directory using SQL (skip the app).
> I am seeking syntax help for this..... if you have a link to a manual, i
> would gladly RTFM... :)
>
> unload to ___??directory/filename??_____
> select * from table

how does the application write to the directory - utl_file or some other method? Received on Thu Aug 25 2005 - 15:37:30 CDT