Home » RDBMS Server » Server Administration » how to reduce the database size after dropping the schema (Oracle10g,Linux)
how to reduce the database size after dropping the schema [message #336873] Tue, 29 July 2008 04:44 Go to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop schema that contains segments otherwise size does not change.

Regards
Michel
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 Go to previous messageGo to next message
svikash
Messages: 3
Registered: July 2008
Junior Member
try to reorganize the tables or deallocate command
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 Go to previous messageGo to next message
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.
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 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You must have to use CASCADE if objects reside inside the schema.
Previous Topic: Packeage Compilation
Next Topic: PCTUSED not permited with index
Goto Forum:
  


Current Time: Sat Dec 10 01:02:15 CST 2016

Total time taken to generate the page: 0.04555 seconds