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

From: Ronald Rood <devnull_at_ronr.nl>
Date: Mon, 29 Aug 2005 07:27:49 +0200
Message-ID: <0001HW.BF386975003D4B05F0284550@news.individual.net>

On Mon, 29 Aug 2005 00:40:43 +0200, NormaJean S via DBMonster.com wrote (in article <5389BBBE84505_at_DBMonster.com>):

> Hi Dave & Jaap,
> thank you in advance for more of your advice. even if you make me RTFM that
> is fine, just point me to the right book :)
>

>>>> .....Assuming the application uses UTL_FILE:

>
> no, i can't assume that. the oracle DBA with more experience than I have
> never mentioned that. She's got more experience, but I am the better
> troubleshooter (with little Oracle experience).
> How would i see if the app is using UTL_FILE?
> I have DBArtisan as a tool.... I just checked.... this instance (oracle 9.
> 2.0.6) has a null/not set UTL_FILE_DIR in the config file.

In 9i you don't need utl_file_dir. Just create the directory object. The unix account that runs the database must have access to the physical directory. The user accounts in the database must have been granted access to the directory object. (read/write).

With kind regards / met vriendelijke groeten, Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle Received on Mon Aug 29 2005 - 00:27:49 CDT