Home » RDBMS Server » Server Administration » tablespace size is same as before deletion of user. (Oracle 11gR2, Redhat linux 5.5)
tablespace size is same as before deletion of user. [message #567434] Mon, 01 October 2012 05:34 Go to next message
ganesh_gvn
Messages: 28
Registered: February 2012
Location: PUNE
Junior Member

Dear All,

I have deleted a user with CASCADE option.

After deletion, the size of tablespace should be reduced.

But the tablespace size is same as before deletion of user.

Currently , that USER is deleted and not present in the database . Still space is not released after user deletion.

Please help me in the above query.

Thanks ,
Ganesh

[Updated on: Mon, 01 October 2012 05:38]

Report message to a moderator

Re: tablespace size is same as before deletion of user. [message #567439 is a reply to message #567434] Mon, 01 October 2012 05:52 Go to previous messageGo to next message
John Watson
Messages: 4669
Registered: January 2010
Location: Global Village
Senior Member
There is no reason why dropping a schema would reduce the size of a tablespace. It might reduce the space used within a tablespace.
Re: tablespace size is same as before deletion of user. [message #567441 is a reply to message #567434] Mon, 01 October 2012 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59399
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
After deletion, the size of tablespace should be reduced.


No, the space used in the tablespace reduces: you have more free space but the tablespace does not.
A tablespace does not shrink by itself, you have to shrink the files yourself and maybe you have to move some objects to be able to do so.

2 good reading:
Database Concepts
Database 2 Day DBA

And some videos
Oracle DBA Lite

Regards
Michel

[Updated on: Mon, 01 October 2012 05:56]

Report message to a moderator

Re: tablespace size is same as before deletion of user. [message #567454 is a reply to message #567441] Mon, 01 October 2012 07:10 Go to previous messageGo to next message
ganesh_gvn
Messages: 28
Registered: February 2012
Location: PUNE
Junior Member

Thanks Michel . Will surely go through above links.

Ganesh
Re: tablespace size is same as before deletion of user. [message #575166 is a reply to message #567454] Sun, 20 January 2013 16:43 Go to previous message
ganesh_gvn
Messages: 28
Registered: February 2012
Location: PUNE
Junior Member

Dear Michel, I read the topics regarding oracle block, extents and segments. understood the concept of table, tablespace, used space,free space .

Quote:
After deletion, the size of tablespace should be reduced.

My question was wrong ..... ..

Thanks for guidance.

Ganesh
Previous Topic: migration of database
Next Topic: ASMlib devices
Goto Forum:
  


Current Time: Mon Oct 20 00:06:55 CDT 2014

Total time taken to generate the page: 0.09228 seconds