Re: inner workings of UTL_FILE.RENAME??

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)