OraFAQ Forum: Server Administration » how to reduce the database size after dropping the schema

Home » RDBMS Server » Server Administration » how to reduce the database size after dropping the schema (Oracle10g,Linux)

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

how to reduce the database size after dropping the schema [message #336873]

Tue, 29 July 2008 04:44

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Hi,

I have checked the my database size from below query

select sum(bytes)/1024/1024/1024 || 'GB'
from dba_segments;

120 GB

I have removed the one schema about 12GB and then i checked the my database size from same query.

select sum(bytes)/1024/1024/1024 || 'GB'
from dba_segments;

120GB.

It shows a same size.how to reduce the database size after dropping schema?

Thanks,
Michael.

Report message to a moderator

Re: how to reduce the database size after dropping the schema [message #336891 is a reply to message #336873]

Tue, 29 July 2008 05:23

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

Senior Member
Account Moderator

Drop schema that contains segments otherwise size does not change.

Regards
Michel

Report message to a moderator

Re: how to reduce the database size after dropping the schema [message #337261 is a reply to message #336873]

Wed, 30 July 2008 05:40

svikash
Messages: 3
Registered: July 2008

Junior Member

try to reorganize the tables or deallocate command

Report message to a moderator

Re: how to reduce the database size after dropping the schema [message #337401 is a reply to message #337261]

Wed, 30 July 2008 15:16

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Drop a user schema including all schema objects (if any).

Below is the Syntax

DROP USER <username> CASCADE;

CASCADE is used to drop all objects in the user's schema.

Report message to a moderator

Re: how to reduce the database size after dropping the schema [message #337458 is a reply to message #336873]

Thu, 31 July 2008 00:01

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You must have to use CASCADE if objects reside inside the schema.

Report message to a moderator

Previous Topic:	Packeage Compilation
Next Topic:	PCTUSED not permited with index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 23:34:27 CDT 2024