OraFAQ Forum: Server Administration » tablespace size is same as before deletion of user.

Home » RDBMS Server » Server Administration » tablespace size is same as before deletion of user. (Oracle 11gR2, Redhat linux 5.5)

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

tablespace size is same as before deletion of user. [message #567434]

Mon, 01 October 2012 05:34

ganesh_gvn
Messages: 39
Registered: February 2012
Location: PUNE

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

John Watson
Messages: 8929
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.

Report message to a moderator

Re: tablespace size is same as before deletion of user. [message #567441 is a reply to message #567434]

Mon, 01 October 2012 05:55

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

ganesh_gvn
Messages: 39
Registered: February 2012
Location: PUNE

Member

Thanks Michel . Will surely go through above links.

Ganesh

Report message to a moderator

Re: tablespace size is same as before deletion of user. [message #575166 is a reply to message #567454]

Sun, 20 January 2013 16:43

ganesh_gvn
Messages: 39
Registered: February 2012
Location: PUNE

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

Report message to a moderator

Previous Topic:	migration of database
Next Topic:	ASMlib devices

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:06:33 CDT 2024