Ives Dekoninck wrote:
> **** Post for FREE via your newsreader at post.usenet.com ****
>
> Hi,
Hi,
>
> I am using an oracle 8i database on a windows NT system.
>
> The problem I am encountering is that the index tablespace is full, and
> my disk is almost full as well... (No buget to upgrade this system at
> the moment:-(().
No comment :-)
>
> The disk only leaves me with 45MB.
>
> In the past I have survived by extending the tablespace. But now I have
> to do something different.
>
> I have seen that the TEMP tablespace is configured with 2GB and there is
> almost none of that space used.
>
> What I would like to do now is to decrease the size of TEMP space and
> put it at 500MB and use the 1,5GB that has been freed up for the index
> tablespace.
Should be no problem, if this is shown as free space in the GUI.
>
> Increasing the size of the tablespace can be done through the GUI but
> can we also decrease the tablespace??
You can shrink the datafiles with the GUI, too.
Select the datafile in the dba Studio/Enterprise Manager and enter the
size (should fit with the extend size). AFAIK you can't damage the DB,
because Oracle gives you a warning if the space is needed and doesn't
shrink the file. You can do this with a running DB.
>
> Thanks for some quick help on this.
>
> BTW. Be aware that this system has a production DB on it. So I want to
> be sure.
Disk space is not expensive. A production DB should be worth it.
>
> Cheers,
>
> -Ives-
Hope this helps,
Holger
Received on Wed Sep 08 2004 - 18:25:36 CDT
