On 5/17/07, DBA Deepak <oracle.tutorials@xxxxxxxxx> wrote:
Can we use UTL_FILE to copy the file as seen by oracle itself to a separate location? Am suggesting the use of something like UTL_FILE because UTL_FILE will be running from within Oracle's environment and Oracle can still see the file.
but Oracle works with processes (under unix machine): from your shadow process (the one that tries to open the redo log file with the utl_file) you won't see the redo log file anymore; only those processes that still keep open the file could see it. Regards. Mario. -- http://www.freelists.org/webpage/oracle-l