... 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 -----------------------------------------------------------------