RE: Move datafiles, but can't delete them
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 RD 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).
RE: Move datafiles, but can't delete them
Tom, I didn't know that I absolutely have to bounce the database. Tx Luc -Original Message- Sent: November 25, 2003 8:36 AM To: '[EMAIL PROTECTED]' Cc: Demanche, Luc 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 RD 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: 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).
RE: Move datafiles, but can't delete them
Luc, Its weird. I've seen it both ways. Sometimes, Windows releases the lock and allows you to delete the file, and sometimes it doesn't. Bouncing the database always allows you to do it. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:43 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Tom, I didn't know that I absolutely have to bounce the database. Tx Luc -Original Message- Sent: November 25, 2003 8:36 AM To: '[EMAIL PROTECTED]' Cc: Demanche, Luc 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 RD 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).
RE: Move datafiles, but can't delete them
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 RD 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).
RE: Move datafiles, but can't delete them
.. 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 RD 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).
RE: Move datafiles, but can't delete them
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. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: 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 RD 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: 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).
RE: Move datafiles, but can't delete them
Side note on this - while you can delete files that are in use by Oracle on UNIX, you have not actually deleted them until there are no processes accessing that file anymore. The file will no longer be there to other applications, but the space used by that now-deleted file will not be released until all of the processes accessing it close their file descriptors. Lsof and fuser are useful tools to track un-reclaimed space due to processes still accessing deleted files. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jared Still Sent: Tuesday, November 25, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Move datafiles, but can't delete them 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. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: 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 RD 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858
RE: Move datafiles, but can't delete them
If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. oh yeah. working on another DBA's databases (he was out ill), and rushed in the wrong directory when gzipping and moving files to free up space. Because Unix keeps the pointers while the file is open, moving the temp tablespace datafiles away (oops!) and back (phew!) did NOT crash the database. --- Jared Still [EMAIL PROTECTED] wrote: 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. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
RE: Move datafiles, but can't delete them
When dropping a tablespace, we've had better success deleting the files by the delete command from CMD rather than using Windows Explorer. Also, found that you need to wait a period of time before you can delete the file - eg try again in 30 secs 5 mins time. This is mentioned in a forum at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=279331.996. From the note below, you should exit your tool (eg SQLPLus) and then wait a bit. Also see note 222033.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=222033.1 which says: fact: Oracle Server - Enterprise Edition 8.1.5 fact: MS Windows NT symptom: Unable to delete datafile from OS after drop tablespace symptom: Cannot delete %s: There has been a sharing violation symptom: Error deleting OS file cause: Bug:480928 OPEN HANDLE TO OFFLINE DATAFILES Fixed in ver. 8.1.6 and higher. fix: After issuing a DROP TABLESPACE command the corresponding datafile is still locked on OS level and not possible to remove. Workaround: Disconnect from the session and exit the tool (Server Manager or SQL*Plus) you were running the DROP TABLESPACE command from. Then wait for some time (minutes) , and the datafile will be released by the OS and possible to delete. To find out who has files open, you can use process explorer from www.sysinternals.com or tlist from the resource kit. HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Wednesday, 26 November 2003 1:49 AM To: Multiple recipients of list ORACLE-L 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. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: 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 RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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).
RE: Move datafiles, but can't delete them
Bruce, Thank you, the problem is not when I dropped the tablespace but want I moved datafiles. I will bounce the database. Luc -Original Message- [mailto:[EMAIL PROTECTED] Sent: November 25, 2003 5:02 PM To: Multiple recipients of list ORACLE-L When dropping a tablespace, we've had better success deleting the files by the delete command from CMD rather than using Windows Explorer. Also, found that you need to wait a period of time before you can delete the file - eg try again in 30 secs 5 mins time. This is mentioned in a forum at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=279331.996. From the note below, you should exit your tool (eg SQLPLus) and then wait a bit. Also see note 222033.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=222033.1 which says: fact: Oracle Server - Enterprise Edition 8.1.5 fact: MS Windows NT symptom: Unable to delete datafile from OS after drop tablespace symptom: Cannot delete %s: There has been a sharing violation symptom: Error deleting OS file cause: Bug:480928 OPEN HANDLE TO OFFLINE DATAFILES Fixed in ver. 8.1.6 and higher. fix: After issuing a DROP TABLESPACE command the corresponding datafile is still locked on OS level and not possible to remove. Workaround: Disconnect from the session and exit the tool (Server Manager or SQL*Plus) you were running the DROP TABLESPACE command from. Then wait for some time (minutes) , and the datafile will be released by the OS and possible to delete. To find out who has files open, you can use process explorer from www.sysinternals.com or tlist from the resource kit. HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Wednesday, 26 November 2003 1:49 AM To: Multiple recipients of list ORACLE-L 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. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: 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 RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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). application/ms-tnef