Home » Infrastructure » Windows » How to delete Source file used by Oracle external table (10.2.0.1.0, MS Windows Server 2003)
How to delete Source file used by Oracle external table [message #454440] Wed, 05 May 2010 10:28 Go to next message
aashi1
Messages: 10
Registered: March 2007
Location: NEW YORK
Junior Member
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,

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454443 is a reply to message #454440] Wed, 05 May 2010 10:33 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member
Quote:
D:\>del test.doc
D:\test.doc
The process cannot access the file because it is being used by another process.


Close if you already open that file & then try to delete

Babu

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454448 is a reply to message #454440] Wed, 05 May 2010 11:12 Go to previous messageGo to next message
Michel Cadot
Messages: 67997
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Exit from SQL*Plus and delete it and OS level, YOU are using the file.

Regards
Michel

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454449 is a reply to message #454448] Wed, 05 May 2010 11:18 Go to previous messageGo to next message
aashi1
Messages: 10
Registered: March 2007
Location: NEW YORK
Junior Member
I shutdown the database, and reboot the server but still not able to remove the file and still getting the same error message.


Thanks,

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454450 is a reply to message #454449] Wed, 05 May 2010 11:28 Go to previous messageGo to next message
Littlefoot
Messages: 21689
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use Unlocker (although it is probably better to release the file, only if you knew what's holding it).

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454454 is a reply to message #454450] Wed, 05 May 2010 11:40 Go to previous messageGo to next message
Michel Cadot
Messages: 67997
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Take care with this site, McAfee warns me it is not safe.

Regards
Michel

[Updated on: Wed, 05 May 2010 11:40]

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454462 is a reply to message #454454] Wed, 05 May 2010 12:28 Go to previous messageGo to next message
aashi1
Messages: 10
Registered: March 2007
Location: NEW YORK
Junior Member
Using Unlocker is rejected by System Administrator due to security reasons. Please let me know any other work around.

Thanks,

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454464 is a reply to message #454462] Wed, 05 May 2010 12:39 Go to previous messageGo to next message
Michel Cadot
Messages: 67997
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try this:

Michel Cadot wrote on Wed, 05 May 2010 18:12
Exit from SQL*Plus and delete it and OS level, YOU are using the file.

Regards
Michel

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454467 is a reply to message #454464] Wed, 05 May 2010 13:17 Go to previous messageGo to next message
aashi1
Messages: 10
Registered: March 2007
Location: NEW YORK
Junior Member
Yes, I tried but no luck.


Thanks,

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454468 is a reply to message #454467] Wed, 05 May 2010 13:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
use classic Windoze solution

Ctrl-Alt-Del

Report message to a moderator

Re: How to delete Source file used by Oracle external table [message #454472 is a reply to message #454468] Wed, 05 May 2010 14:50 Go to previous message
aashi1
Messages: 10
Registered: March 2007
Location: NEW YORK
Junior Member
CTRL+ALT+DEL works. Finally, I'm able to remove the file.

Thanks for all your help.

Report message to a moderator

Previous Topic: how to get connectivity between sql server and oracle
Next Topic: LRM-00109: could not open Pfile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 20 11:45:07 CDT 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.