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: RE: utl_file_dir

RE: RE: utl_file_dir

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Thu, 30 Nov 2000 09:59:26 -0500
Message-Id: <10696.123324@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C05ADE.224473D0
Content-Type: text/plain;

        charset="iso-8859-1"

Why not to start a new thread?

Alex Hillman

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Thursday, November 30, 2000 9:37 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: utl_file_dir

Folks,

    I know I really don't like it when someone changes the direction of a thread, but this does segway into a question I have recently been asking.

    We had a rep from Net Appliance here the other day to pitch their filer as a
solution for our disk space problems. They pitched it as both a NT file system
solution (home drives & the like) and a Unix solution for the DB's as well. One
question I had was could a Unix host see and/or create files on the filer that
could then be shared by the NT side. He said YES. Hummmmm!! Now that could
cure some of my headaches. Therefore, is anyone out there using a NetApp Filer?? If so, How??

Dick Goulet

____________________Reply Separator____________________
Author: "Raghunath; Shivaswamy" <Shivaswamy.Raghunath_at_qwest.com>
Date:       11/29/2000 4:12 PM

 

Thanks for your reply, Dave Turner.

But my latter reference says me thus:

utl_file is a utility for server-side only. Which means that, we can use only the directories on the server and directories on no other box is permittted. TEXT_IO package of Oracle Developer could be used for the client side.

Thanks, however,
Shiva
-----Original Message-----
To: Raghunath, Shivaswamy
Sent: 11/29/2000 6:44 PM

Have them nfs mount the directory on the remote machine. I don't know if this is
supported by oracle.

Dave Turner
On Wed, Nov 29, 2000 at 02:15:27PM -0800, Raghunath, Shivaswamy wrote:
> Hi All,
>
> Can I have utl_file_dir set to a directory, on a remote box.(Other
than the
> server)? We do not have unix accounts to developers on the server and
unix
> clients are used by developers. If so how do I specify in the init
file? (I
> request you to cc me)
>
> TIA,
> Shiva
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Raghunath, Shivaswamy
> INET: Shivaswamy.Raghunath_at_qwest.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_at_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghunath, Shivaswamy
  INET: Shivaswamy.Raghunath_at_qwest.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_at_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.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_at_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).

------_=_NextPart_001_01C05ADE.224473D0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: RE: utl_file_dir</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>Why not to start a new thread?</FONT>
</P>

<P><FONT SIZE=2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: dgoulet_at_vicr.com [<A HREF="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, November 30, 2000 9:37 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Re:RE: utl_file_dir</FONT>
</P>
<BR>

<P><FONT SIZE=2>Folks,</FONT>
</P>

<P><FONT SIZE=2>&nbsp;&nbsp;&nbsp; I know I really don't like it when someone changes the direction of a</FONT>
<BR><FONT SIZE=2>thread, but this does segway into a question I have recently been asking.</FONT>
</P>

<P><FONT SIZE=2>&nbsp;&nbsp;&nbsp; We had a rep from Net Appliance here the other day to pitch their filer as a</FONT>
<BR><FONT SIZE=2>solution for our disk space problems.&nbsp; They pitched it as both a NT file system</FONT>
<BR><FONT SIZE=2>solution (home drives &amp; the like) and a Unix solution for the DB's as well.&nbsp; One</FONT>
<BR><FONT SIZE=2>question I had was could a Unix host see and/or create files on the filer that</FONT>
<BR><FONT SIZE=2>could then be shared by the NT side.&nbsp; He said YES.&nbsp; Hummmmm!!&nbsp; Now that could</FONT>
<BR><FONT SIZE=2>cure some of my headaches.&nbsp; Therefore, is anyone out there using a NetApp</FONT>
<BR><FONT SIZE=2>Filer??&nbsp; If so, How??</FONT>
</P>

<P><FONT SIZE=2>Dick Goulet</FONT>
</P>

<P><FONT SIZE=2>____________________Reply Separator____________________</FONT>
<BR><FONT SIZE=2>Author: &quot;Raghunath; Shivaswamy&quot; &lt;Shivaswamy.Raghunath_at_qwest.com&gt;</FONT>
<BR><FONT SIZE=2>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/29/2000 4:12 PM</FONT>
</P>

<P><FONT SIZE=2>&nbsp;</FONT>
<BR><FONT SIZE=2>Thanks for your reply, Dave Turner.</FONT>
</P>

<P><FONT SIZE=2>But my latter reference says me thus:</FONT>
</P>

<P><FONT SIZE=2>utl_file is a utility for server-side only. Which means that, we can use </FONT>
<BR><FONT SIZE=2>only the directories on the server and directories on no other box is</FONT>
<BR><FONT SIZE=2>permittted. TEXT_IO package of Oracle Developer could be used for the client</FONT>
<BR><FONT SIZE=2>side. </FONT>
</P>

<P><FONT SIZE=2>Thanks, however,</FONT>
<BR><FONT SIZE=2>Shiva</FONT>
<BR><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>To: Raghunath, Shivaswamy</FONT>
<BR><FONT SIZE=2>Sent: 11/29/2000 6:44 PM</FONT>
</P>

<P><FONT SIZE=2>Have them nfs mount the directory on the remote machine. I don't know if</FONT>
<BR><FONT SIZE=2>this is</FONT>
<BR><FONT SIZE=2>supported by oracle.</FONT>
</P>

<P><FONT SIZE=2>Dave Turner</FONT>
<BR><FONT SIZE=2>On Wed, Nov 29, 2000 at 02:15:27PM -0800, Raghunath, Shivaswamy wrote:</FONT>
<BR><FONT SIZE=2>&gt; Hi All,</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Can I have utl_file_dir set to a directory, on a remote box.(Other</FONT>
<BR><FONT SIZE=2>than the</FONT>
<BR><FONT SIZE=2>&gt; server)? We do not have unix accounts to developers on the server and</FONT>
<BR><FONT SIZE=2>unix</FONT>
<BR><FONT SIZE=2>&gt; clients are used by developers. If so how do I specify in the init</FONT>
<BR><FONT SIZE=2>file? (I</FONT>
<BR><FONT SIZE=2>&gt; request you to cc me)</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; TIA,</FONT>
<BR><FONT SIZE=2>&gt; Shiva</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; -- </FONT>
<BR><FONT SIZE=2>&gt; Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>&gt; -- </FONT>
<BR><FONT SIZE=2>&gt; Author: Raghunath, Shivaswamy</FONT>
<BR><FONT SIZE=2>&gt;&nbsp;&nbsp; INET: Shivaswamy.Raghunath_at_qwest.com</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>&gt; --------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt; also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Raghunath, Shivaswamy</FONT>
<BR><FONT SIZE=2>&nbsp; INET: Shivaswamy.Raghunath_at_qwest.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2>&nbsp; INET: dgoulet_at_vicr.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
Received on Thu Nov 30 2000 - 08:59:26 CST

Original text of this message

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