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

Home -> Community -> Usenet -> c.d.o.misc -> Re: inner workings of UTL_FILE.RENAME??

Re: inner workings of UTL_FILE.RENAME??

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 21 Oct 2004 22:02:12 -0700
Message-ID: <1098421279.520028@yasure>


underthegun wrote:

> We are using the UTL_FILE.RENAME function to give created files good names
> after they are complete (we use temporary names at creation time and use
> that name while still writing the file). Can anyone tell me the logic
> that Oracle uses to perform these file renames on the UNIX system? We
> occasionally run into trouble when another piece of software, looking for
> completed files (ignores files with "TEMP" in the front of the file name),
> tries to pick up one of the files that is being renamed from it's
> TEMP_<filename> to <filename>.

Don't know but I'd be surprised if it was much more than mv.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Oct 22 2004 - 00:02:12 CDT

Original text of this message

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