RE: Move datafiles, but can't delete them

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 25 Nov 2003 05:24:26 -0800
Message-ID: <F001.005D7C48.20031125052426@fatcity.com>

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). Received on Tue Nov 25 2003 - 07:24:26 CST