Space issue

[rshivagami]

Hi all,

Our server is running out of space. And it has 3 databases running on it. I have compacted all the files possible. ( It has no junk at all) Is it possible to compact any of the data files(they seem to occupy more space), would it affect anything. I do not even have ARCHIVELOG turned on. Or is increasing the tablespace the only solution.

Any suggestions on what can be done ??
Thanks,
Shiva.

[Kishore]

How much your tablespaces are filled. you may want to try resizing the Datafile. If might help

[jdorlon]

If the databases are the same version and using separate ORACLE_HOMEs, you could put them all under the same home.

I don't know of any way to compact datafiles.

If your tablespaces are very fragmented you might be able to reclaim some space by reorganizing them, but it can be a long process and you might not gain very much.

I think you have to convince management to buy more disks!

-John

[aarganesh]

if U insert & delete too many rows often from your tablespace, consider issuing ALTER DEALLOCATE UNUSED, which may show some small increase in space. There is no way to compact the datafile size