Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> UTL_FILE.RENAME
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 Sun Mar 07 2004 - 23:35:53 CST