Decrease temp tablesapce

• Post for FREE via your newsreader at post.usenet.com ****

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:-(().

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.

Increasing the size of the tablespace can be done through the GUI but can we also decrease the tablespace??

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.

Cheers,

-Ives-

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=