.. and the reason you don't get the space back immediately is because the file is still open, and not actually deleted yet.
Jared On Tue, 2003-11-25 at 06:24, Goulet, Dick wrote: > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).