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,
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: 1736
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
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: 68625
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
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,
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: 21806
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).
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: 68625
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,
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: 68625
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

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,
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
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.


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


Current Time: Fri Mar 29 09:47:08 CDT 2024