| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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:Bruce.Reardon_at_comalco.riotinto.com.au]
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=FOR&p_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=NOT&p_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
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 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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: Bruce.Reardon_at_comalco.riotinto.com.au 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 - 16:04:35 CSTContent-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification. ------_=_NextPart_000_01C3B3A0.131268FE-- -- 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).
- application/ms-tnef attachment: stored
 |
 |