RE: Create Directory Vs UTL_FILE_DIR

  • From: Jared.Still@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 12 Feb 2004 10:16:23 -0800

... and it is used for creating external tables.
Jared






Connor McDonald <hamcdc@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
 02/11/2004 10:09 PM
 Please respond to oracle-l

 
        To:     oracle-l@xxxxxxxxxxxxx
        cc: 
        Subject:        RE: Create Directory Vs UTL_FILE_DIR


yup.

but in ver 9 , utl_file_dir is deprecated, (replaced with 'create dir')

 --- Jay <jaysingh1@xxxxxxxxxxxxx> wrote: > so I can not write into file 
system directory which is
created using "create
> Directory" command. Right?
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jacques Kilchoer
> Sent: Wednesday, February 11, 2004 8:17 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: Create Directory Vs UTL_FILE_DIR
> 
> 
> No. CREATE DIRECTORY is to create an alias to a directory on the OS file 
=
> system that will contain BFILEs for database LOBS.
> UTL_FILE_DIR is still needed for UTL_FILE.
> 
> > -----Original Message-----
> > Jay
> >=20
> > In oracle 8i and can we use "create directory" command is the=20
> > replacement
> > for UTL_FIR_DIR parameter?




----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: