Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: utl_file_dir parameter

RE: utl_file_dir parameter

From: Linda Wang <lwang_at_messagemedia.com>
Date: Tue, 17 Oct 2000 17:05:29 -0600
Message-Id: <10652.119565@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0016_01C0385C.744094B0 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

utl_file_dir parameterutl_file_dir = /directory/users   -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Baylis, John   Sent: Tuesday, October 17, 2000 5:26 PM   To: Multiple recipients of list ORACLE-L   Subject: utl_file_dir parameter

  We would like to create files in various directories on HP unix using the utl_file package

       Since what we really need is

       utl_file_dir = /directory/users/*                  which does not
work,

       and we do not want to specify the following due to security reasons, is there any alternative methods that are available to accomplish this?

       utl_file_dir = *

  Are there other techniques or work arounds?

  John Baylis
  DBA / Systems Administrator
  Canadian Forest Products Ltd.
  Vancouver B.C. Canada

------=_NextPart_000_0016_01C0385C.744094B0 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>utl_file_dir parameter</TITLE>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>utl_file_dir =3D /<FONT face=3DArial=20
size=3D2>directory</FONT><FONT face=3DArial = size=3D2>/users</FONT></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader><FONT face=3D"Times New Roman"=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of</B> Baylis, = John<BR><B>Sent:</B>=20
  Tuesday, October 17, 2000 5:26 PM<BR><B>To:</B> Multiple recipients of = list=20
  ORACLE-L<BR><B>Subject:</B> utl_file_dir = parameter<BR><BR></DIV></FONT>
<P><FONT face=3DArial size=3D2>We would like to create files in =
various=20
  directories on HP unix using the utl_file package</FONT> </P>
<P><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;&nbsp; Since =
what</FONT><FONT=20
  face=3DArial size=3D2> we</FONT> <FONT face=3DArial size=3D2>really = need is</FONT>=20
</P>
<P><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;&nbsp; utl_file_dir =
=3D=20
  /</FONT><FONT face=3DArial size=3D2>directory</FONT><FONT face=3DArial =

  size=3D2>/users/*&nbsp;&nbsp;&nbsp;&nbsp;</FONT> = &nbsp;&nbsp;&nbsp;&nbsp;=20
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial = size=3D2>which does=20
  not work,</FONT> </P><BR>
<P><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;</FONT> <FONT =
face=3DArial=20
  size=3D2>and we do not want to specify the following due to security = reasons, is=20
  there any alternative methods that are available to accomplish=20

this?</FONT></P>

<P><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;&nbsp; utl_file_dir =
=3D *</FONT>=20
</P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>Are there other =
techniques or work=20
  arounds?</FONT> </P>
<P><B><FONT color=3D#000080 face=3DTahoma size=3D2>John =
Baylis</FONT></B> <BR><FONT=20
  face=3DTahoma size=3D2>DBA / Systems Administrator</FONT> <BR><FONT = face=3DTahoma=20
  size=3D2>Canadian Forest Products Ltd.</FONT> <BR><FONT face=3DTahoma=20   size=3D2>Vancouver B.C. Canada</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Tue Oct 17 2000 - 18:05:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US