How to delete Source file used by Oracle external table [message #454440] |
Wed, 05 May 2010 10:28  |
|
Hi,
I'm getting the following error message while deleting the source file used by Oracle external table. The table already been dropped, and now attempting to delete the file and getting this error.
SQL> host del acctinv.txt
E:\GCIMS\Data\acctinv.txt
The process cannot access the file because it is being used by another process.
How to know which process is using this file, and how to kill that process? Please advice.
Thanks,
|
|
|
|
|
|
|
|
|
|
|
|
|