Message-ID: <F001.004BC88E.20020822062326@fatcity.com>
Date: Thu, 22 Aug 2002 06:23:26 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: =?iso-8859-1?q?Connor=20McDonald?= <hamcdc@yahoo.co.uk>
Subject: Re: utl_file_dir vs create directory
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

a) its dynamic (so bounce needed)
b) its more granular - you can grant read/readwrite
etc

hth
connor

 --- Rachel Carmichael <wisernet100@yahoo.com> wrote:
> Okay, I'll admit I know nothing about the create
> directory command and
> am off to read the fine manuals as soon as I hit
> send on this....
> 
> my developer sent me an email saying "do you know of
> this new feature
> create_directory? it is recommended to use
> create_directory instead of
> utl_file_dir"
> 
> First, she's not in, I can't ask her WHO recommended
> it. But I will.
> Second, I think she meant create directory, without
> the underscore.
> 
> Basically what we are doing is reading an orders
> table and generating a
> flat file to be shipped to the fulfillment center.
> This will be done
> via a PL/SQL procedure which will be called at
> regularly scheduled
> times.
> 
> Why would I want/need to use create directory
> instead of utl_file?  The
> database will go live in 9.2.0.1
> 
> Any advice is welcome!
> 
> Rachel
> 
> 
> __________________________________________________
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: wisernet100@yahoo.com
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California        -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=====
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Remember amateurs built the ark - Professionals built the Titanic"

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc@yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).