| Space not reducing [message #64383] |
Thu, 20 January 2005 19:08  |
Roshan Maharjan
Messages: 4
Registered: January 2005
|
Junior Member |
|
|
Hi,
I deleted most of my Old data in huge volume, but the physical space is not reducing in my HDD....
Why is that???
Thank you.
Regards,
Roshan
|
|
|
|
|
|
| Re: Space not reducing: [message #64385 is a reply to message #64384] |
Thu, 20 January 2005 21:21  |
Roshan Maharjan
Messages: 4
Registered: January 2005
|
Junior Member |
|
|
HI,
Occupying Space by Tablespaces
SYSTEM = 14,564 MB (17.62%)
Tools = 60.62 MB ( 99.54%)
RBS = 2,545.00 MB ( 88.96%)
Now, my HDD storage capacity is only 30GB and about 4.85 GB is now free.
I deleted old data from Tables which contained huge number of Data but still the HDD size is not increased.
Can u suggest me how to increase my HDD Size since I have deleted the Data from the Tables. and also did
COALESCE of the Tablespaces like SYSTEM, TOOLS, RBS.
Hope to Hear from you soon.
Thank you.
Regards,
Roshan
|
|
|
|
| Re: Space not reducing: [message #64386 is a reply to message #64385] |
Thu, 20 January 2005 21:47 |
ajay
Messages: 45
Registered: December 2000
|
Member |
|
|
when we perform deletion on a table, it delete the data but not reset the high water mark.
for reseting high water mark,
recreate the table and insert all rows.
or Move table into other tablespace
or export the table, drop the table , import the table.
SYSTEM = 14,564 MB (17.62%)
i am not clear about system tablespace.
Pls. tell me about
total size of SYSTEM tablespace
total free size of SYSTEM tablespace
Is there all object in SYSTEM tablepsace?
|
|
|
|
|
|
| Re: Space not reducing: [message #64394 is a reply to message #64391] |
Fri, 21 January 2005 03:50 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Ok.
IN oracle, you store your data in index/ tables.
these objects are stored in tablespaces ( which are physically defined by one or more pre-allocated datafiles in your hard disk).
Deleting the table data will not free space in datafiles.
You have to truncte the data in table or drop table/index.
Even though, You will NOT see the associated datafile to shrink in size. With oracle utilities you can see the used space ( by data) is reduced or there is more free size within the datafile.
But the datafile allocated size REMAINS the same.
What you can do is SHRINK the size of tablespace ( ie..the datafiles that defined physically).
>>Can u suggest me how to increase my HDD Size since I
>> ave deleted the Data from the Tables. and also did
>>COALESCE of the Tablespaces like SYSTEM, TOOLS, RBS.
None above will actually shrink the datafiles in your harddisk.
You need to find the actual space used by objects with thin the tablespace and you can shrink only upto that.
BigBrother Tom has something to say here. Please please check it out
And these are only for tablespace that holds data.
for TEMP and RBS tablespaces you have design them properly.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
