Re: Moving File after using it in external table load

From: Mark D Powell <>
Date: Thu, 30 Oct 2008 11:14:21 -0700 (PDT)
Message-ID: <>

On Oct 29, 4:23 pm, Randall <> wrote:
> Using Oracle on Windows XP.
> I am loading a file into an external table then dropping the table and
> trying to move the file used to create the external table to another
> folder.  A lock is maintained on the file even after droppping the
> table.  Is there some method of releasing the lock so I can move the
> file ... or am I missing something.
> Thanks in advance,
> Randall

Did the session that accessed the file via an external table select commit or rollback to end its processing?

Was the session terminated (exited) after it was done being used to process the table?

Please resond back with what ever information you determine.

HTH -- Mark D Powell -- Received on Thu Oct 30 2008 - 13:14:21 CDT

Original text of this message