Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nntp.theplanet.net!inewsm1.nntp.theplanet.net!newsfeed00.sul.t-online.de!t-online.de!news.karotte.org!news2.arglkargh.de!noris.net!newsfeed.arcor.de!news.arcor.de!not-for-mail
Date: Tue, 06 Jun 2006 16:17:45 +0200
From: Maxim Demenko <mdemenko@arcor.de>
Reply-To:  mdemenko@gmail.com
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: de-DE, de, en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: service name / invalid directory path
References: <1149588804.908212.252090@c74g2000cwc.googlegroups.com> <1149591800.480083.63450@y43g2000cwc.googlegroups.com> <j4qa82tu4ct8665roaqlf24cofqcnqq5fb@4ax.com> <44857b2a$0$11072$9b4e6d93@newsread4.arcor-online.net> <MPG.1eef9b783a10507898a1fc@news.individual.net>
In-Reply-To: <MPG.1eef9b783a10507898a1fc@news.individual.net>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 66
Message-ID: <44858fe1$0$4514$9b4e6d93@newsread2.arcor-online.net>
Organization: Arcor
NNTP-Posting-Date: 06 Jun 2006 16:23:29 MEST
NNTP-Posting-Host: 4b88f929.newsread2.arcor-online.net
X-Trace: DXC=oZ[AnPn1m=L[T<j>26?78JQ5U85hF6f;DjW\KbG]kaMH[NGU2GAcMGJ?7do]<NXGQA_o3Gk\lAX[G\F3oceh^D4LR9boY;9DVCM
X-Complaints-To: usenet-abuse@arcor.de
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268623

Jeremy schrieb:
> In article <44857b2a$0$11072$9b4e6d93@newsread4.arcor-online.net>, Maxim 
> Demenko says...
> 
>>Sybrand Bakker schrieb:
>>
>>>On 6 Jun 2006 04:03:20 -0700, "fitzjarrell@cox.net"
>>><fitzjarrell@cox.net> wrote:
>>>
>>>
>>>
>>>>It appears you missed a crucial step:
>>>>
>>>>create or replace directory <dirname> as '<pathname>';
>>>>
>>>>where <dirname> is the directory name you intend to use and <pathname>
>>>>is the <directory_name> you set  UTL_FILE_DIR to.  If, for example, you
>>>>set UTL_FILE_DIR = '/mydir/for/general/stuff' and your stored procedure
>>>>uses the string 'mydir' in the utl_file calls then the create directory
>>>>command should appear thus:
>>>>
>>>>create or replace directory mydir as '/mydir/for/general/stuff';
>>>
>>>
>>>David,  create directory wasn't available in 8i. It's a 9i statement.
>>>
>>>--
>>>Sybrand Bakker, Senior Oracle DBA
>>
>>David is probably correct on it.
>>
>>sqlplus "/ as sysdba"
>>
>>SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jun 6 14:49:34 2006
>>
>>(c) Copyright 2000 Oracle Corporation.  All rights reserved.
>>
>>
>>Connected to:
>>Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
>>With the Partitioning option
>>JServer Release 8.1.7.4.0 - Production
>>
>>SQL> create directory tmp as '/tmp';
>>
>>Directory created.
>>
>>SQL>
>>
>>
>>
> IIRC you couldn't use UTL_FILE on a directory object in 8i - directories 
> were there for other purposes - in 8i you still had to define the 
> UTL_FILE_DIR in the init.ora
> 
> I could be wrong but don't think I am.
> 
> (famous last words..)
> 
> 

Oh, i see your ( and Sybrand's) point, sorry for noise.

Best regards

Maxim