how to test unload to a directory defined in DB

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

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200508/1