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

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sat, 27 Aug 2005 11:04:42 +0200
Message-ID: <85b0h1pf029du581mpl5lqa7od3obil984@4ax.com>

On Thu, 25 Aug 2005 19:32:28 GMT, "NormaJean S via DBMonster.com" <forum_at_DBMonster.com> wrote:

>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
>
>thanks for your advice.
>NJ

Assuming the application uses UTL_FILE:
1) what is the unix account the database is started with? 2) can this account reach the directory (is the x-bit set for this account for all parent directories and the directory itself?) 3) can this account write in the directory? 4) Does the file that the application wants to write to, already exists under another account, so that the file can not be overwritten?

Jaap. Received on Sat Aug 27 2005 - 04:04:42 CDT