RE: Move datafiles, but can't delete them

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 25 Nov 2003 06:24:25 -0800
Message-ID: <F001.005D7C53.20031125062425@fatcity.com>

What is most likely happening is that a server, as in client dedicated, has an interest in those files & consequently Windoze won't let you delete then until the end user terminates their session. Now while Unix won't give you an error in this situation you'll notice that you don't get the disk space back immediately. Also on Unix, provided you have a helpful SA, you can run an fuser on the files to find out who is using them.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Tuesday, November 25, 2003 8:24 AM To: Multiple recipients of list ORACLE-L

Luc,

The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason.

In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L

Hi gurus,

Oracle 8.1.7.4 on Windows 2000
Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk.

1- I placed my tablespace offline
2- I copied my 2 datafiles
3- I altered my controlfiles to reflect the new path
4- I brought my tablespace back online
5- I backuped up my controlfile to trace to make sure it using the new path
6- When I wanted to delete the 2 old datafiles, Windows gave me an "sharing

violation" error.

My question is Who using it?

My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. ....
I don't want to bounce my production database ....

Any ideas

TIA
Luc

---

Luc Demanche
AstraZeneca R&D Montreal
Oracle Database Administrator
514.832.3200 x2356

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: Luc.Demanche_at_astrazeneca.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Goulet, Dick
  INET: DGoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 25 2003 - 08:24:25 CST