Move datafiles, but can't delete them

From: <Luc.Demanche_at_astrazeneca.com>
Date: Tue, 25 Nov 2003 05:09:27 -0800
Message-ID: <F001.005D7C44.20031125050927@fatcity.com>

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