Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!j33g2000cwa.googlegroups.com!not-for-mail From: "Mark D Powell" Newsgroups: comp.databases.oracle.server Subject: Re: utl_file_dir in RAC Date: 30 Mar 2006 12:20:24 -0800 Organization: http://groups.google.com Lines: 22 Message-ID: <1143750024.034290.295840@j33g2000cwa.googlegroups.com> References: <1143744884.663243.263730@j33g2000cwa.googlegroups.com> <1143748311.258011@yasure.drizzle.com> NNTP-Posting-Host: 192.85.50.1 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1143750029 3439 127.0.0.1 (30 Mar 2006 20:20:29 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 30 Mar 2006 20:20:29 +0000 (UTC) In-Reply-To: <1143748311.258011@yasure.drizzle.com> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: j33g2000cwa.googlegroups.com; posting-host=192.85.50.1; posting-account=J7QqBQwAAABTieek3RP_669Gs2iATWzr Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:264525 The spfile format does support associating a parameter value to a specific RAC instance so in theory you could have different values in the utl_file parameter for the two instances. But you will have to make sure that code that uses a specific directory always runs on the correct server or an error will result. I do not understand why you would want this unless you were on a platform without a shared file system in which case the most common solution would probably be to NFS mount a file so that all db servers could access one common structure. But from experience I know you can add a file that exists on only one node to a RAC system and it will run just fine until such time as another instance attempts to access something allocated to the file. Not a good thing. The "in theory" part means I have not tested this. The utl_file parameter still exists in 10.2 but like Daniel said you should really be using CREATE DIRECTORY. HTH -- Mark D Powell --