Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE.RENAME
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...Received on Mon Mar 08 2004 - 00:55:04 CST
> 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)
>