Unable to physically remove EXAMPLE dataf ile [message #57402] |
Thu, 12 June 2003 06:02 |
Amber Fatima
Messages: 19 Registered: September 1999
|
Junior Member |
|
|
I am using oracle 9i Rel. 2 , in my production database. i have use this command to delete tablespace EXAMPLE :
drop tablespace EXAMPLE including contents and datafiles;
before doing this i just drop all users with cascade option , exist in the EXAMPLE tablespace.
I forget to run drop scripts of demo schemas.
it deleted all data segments from database , but it can't do physical deletion of example01.dbf file on oradata folder . Error exist in trace file as :
Encountered error when executing :
DROP VIEW QS.aq$AQ$_MEM_MC_R
ORA-01259: unable to delete datafile D:ORACLEORADATAEXAMPLE01.DBF
ORA-27056: skgfrdel: could not delete file
OSD-04024: Unable to delete file.
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
I have confusion whether i delete manually from the oradata folder , will it ask for media recovery for not - exist tablespace ,in my 24 hrs running database ?
I have done also creating a backup control file to trace , where i didn't find EXAMPLE tablespace or its datafile info .
Pl. any help will be great .
Thanks
|
|
|