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: UTL_FILE.RENAME

Re: UTL_FILE.RENAME

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 8 Mar 2004 06:55:04 -0000
Message-ID: <404c18c6$0$14414$cc9e4d1f@news.dial.pipex.com>


check the os permissions first, I believe you need delete as well as read/write

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1078724120.940321_at_yasure...

> Having a problem with a demo that is so simple I've not doubt I'll be
> totally embarrassed by the solution.
>
> Here's my code and the 9.2.0.4 W2K response:
>
> SQL> BEGIN
> 2 utl_file.frename('ORALOAD', 'test.txt', 'ORALOAD', 'x.txt', TRUE);
> 3 END frename;
> 4 /
> BEGIN
> *
> ERROR at line 1:
> ORA-29292: file rename operation failed
> ORA-06512: at "SYS.UTL_FILE", line 18
> ORA-06512: at "SYS.UTL_FILE", line 1108
> ORA-06512: at line 2
>
> I have already built demos that test every other aspect of UTL_FILE
> including fremove so I know the directory is correct and the file
> name is correct.
>
> A search of metalink was of no value.
>
> Thanks, in advance, for any help on this one.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Mon Mar 08 2004 - 00:55:04 CST

Original text of this message

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