NNTP-Posting-Date: Mon, 03 Mar 2003 09:24:32 -0600 From: "Peter Shankey" Newsgroups: comp.databases.oracle References: <2588346.1046453599@dbforums.com> <3E60B973.1040307@OracleCare.Com> Subject: Re: Can UTL_FILE access client side file system Date: Mon, 3 Mar 2003 09:24:32 -0600 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Lines: 25 NNTP-Posting-Host: 12.237.223.180 X-Trace: sv3-6if0L1iOR0bYLVjWggRsdzMoWLfVNsFa6p6w3F81g9zS5KttYU+6sXphvLVHmLcCwAjref66+AyGgXi!MqI3MNZgKc6LGMULHiFgvhqWA8bTK3A9Tt042p0i1dbFxQl6Uln2Wx1j/nNDuUw= X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 "Svend Jensen" wrote in message news:3E60B973.1040307@OracleCare.Com... > Yes, if several conditions are met. > > In windoze 2K Server and oracle 8.1.7: > > The client drive must be a domain share on the db server. > Utl_file parameter set accordingly, or '*' (security issue) > The OracleServiceSID must log on as domain admin or user with similar > privs. In service right click, log on as, restart. > > Other platforms; create more specific questions :-) > > /Svend Jensen > It seems to me Svend's idea would work fine in a small (<500) situation, assuming the db server is beefy. In a large situation, the network traffic to maintain the share and the memory required to maintain the share would make this a bad solution. Granted it take a small amount of traffic and memory to make a share, but it must add up at some point.