Home » RDBMS Server » Server Administration » Tablespace issue (10.2.0.4, windows 2003)
Tablespace issue [message #426269] Wed, 14 October 2009 11:48 Go to next message
pleasehelp
Messages: 21
Registered: January 2007
Junior Member
Hi all,

I'm having problem with deleting the physical datafiles on our database server..

I tried the below command to drop the tablespace of 110Gb with 3 datafiles..

SQL>drop tablespace tsname including contents and datafiles;

Tablespace dropped.

I checked in v$tablespace and v$datafile, the tablespace and the datafiles are gone. But, I'm trying to delete the physical datafiles on the database server to free up the space but when I delete them it tells me, It is being used by another person or program..

Thank you
Re: Tablespace issue [message #426271 is a reply to message #426269] Wed, 14 October 2009 11:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is Windows, it keeps the memory of the handle Oracle got on the files until you shut the instance down.

Regards
Michel

[Updated on: Wed, 14 October 2009 11:52]

Report message to a moderator

Re: Tablespace issue [message #426273 is a reply to message #426269] Wed, 14 October 2009 11:53 Go to previous messageGo to next message
pleasehelp
Messages: 21
Registered: January 2007
Junior Member
So, do I need to restart the database to free up the space on the server? There are 3 instances running on this server. DO I need to shutdown all 3 ?

Thanks much
Re: Tablespace issue [message #426275 is a reply to message #426273] Wed, 14 October 2009 12:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only the one which owned the tablespace you dropped.

Regards
Michel
Re: Tablespace issue [message #426642 is a reply to message #426271] Sat, 17 October 2009 12:13 Go to previous messageGo to next message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
If the datafile belongs to tablespace database windows.You need to shutdown the database and you need to go at a particular drive to delete the file.

Thanks,
Afroze.
Re: Tablespace issue [message #426643 is a reply to message #426642] Sat, 17 October 2009 12:49 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As always your post does not add anything to the previous poszts.

Thanks
Michel
Previous Topic: Automatic Silent ASM configuration on Windows
Next Topic: SQL_ID for Fine Grant Auditing statement
Goto Forum:
  


Current Time: Fri Dec 02 14:32:08 CST 2016

Total time taken to generate the page: 0.34647 seconds