OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Tablespace issue (10.2.0.4, windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace issue [message #426269]

Wed, 14 October 2009 11:48

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

Report message to a moderator

Re: Tablespace issue [message #426271 is a reply to message #426269]

Wed, 14 October 2009 11:52

Michel Cadot
Messages: 68665
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

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

Report message to a moderator

Re: Tablespace issue [message #426275 is a reply to message #426273]

Wed, 14 October 2009 12:01

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Only the one which owned the tablespace you dropped.

Regards
Michel

Report message to a moderator

Re: Tablespace issue [message #426642 is a reply to message #426271]

Sat, 17 October 2009 12:13

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.

Report message to a moderator

Re: Tablespace issue [message #426643 is a reply to message #426642]

Sat, 17 October 2009 12:49

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 09:19:12 CDT 2024