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

Home -> Community -> Usenet -> c.d.o.server -> Re: service name / invalid directory path

Re: service name / invalid directory path

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Tue, 06 Jun 2006 14:49:22 +0200
Message-ID: <44857b2a$0$11072$9b4e6d93@newsread4.arcor-online.net>


Sybrand Bakker schrieb:

> On 6 Jun 2006 04:03:20 -0700, "fitzjarrell_at_cox.net"
> <fitzjarrell_at_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> Best regards

Maxim Received on Tue Jun 06 2006 - 07:49:22 CDT

Original text of this message

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