OraFAQ Forum: Windows » How to delete Source file used by Oracle external table

Home » Infrastructure » Windows » How to delete Source file used by Oracle external table (10.2.0.1.0, MS Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to delete Source file used by Oracle external table [message #454440]

Wed, 05 May 2010 10:28

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

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

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

Michel Cadot
Messages: 68417
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

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

Littlefoot
Messages: 21759
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

Michel Cadot
Messages: 68417
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

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

Michel Cadot
Messages: 68417
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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 16:49:41 CDT 2023