how to reduce the database size after dropping the schema [message #336873] |
Tue, 29 July 2008 04:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
|
|
|