RE: Create Directory Vs UTL_FILE_DIR

From: <Jared.Still_at_radisys.com>
Date: Thu, 12 Feb 2004 10:16:23 -0800
Message-ID: <OFF8602B6B.3F0534DB-ON88256E38.0064529B-88256E38.00644F1E@radisys.com>

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

Connor McDonald <hamcdc_at_yahoo.co.uk>
Sent by: oracle-l-bounce_at_freelists.org
 02/11/2004 10:09 PM
 Please respond to oracle-l  

        To:     oracle-l_at_freelists.org
        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_at_optonline.net> wrote: > so I can not write into file system directory which is created using "create
  > Directory" command. Right?
  >
  > -----Original Message-----
  > From: oracle-l-bounce_at_freelists.org
  > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jacques Kilchoer
  > Sent: Wednesday, February 11, 2004 8:17 PM
  > To: oracle-l_at_freelists.org
  > 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 12 2004 - 12:16:23 CST