Re: Temporary segments in tablespace after drop object

From: Pierre <proussin_at_tactik.com>
Date: Wed, 10 Jun 1998 14:25:36 GMT
Message-ID: <AHwf1.3552$gY.5460055@news21.bellglobal.com>

Hi,

    One way I found to do this is to force smon to execute.

    Do this:

                    Create table X (x varchar2(1))
                    tablespace <tablespace where temp segment is>
                    storage(initial 1M next <larger than size of tablespace>

minextents 2);

                    The command will fail and smon will be forced to

execute.

            CIAO
boeckmans wrote in message <357E8881.19287CBE_at_btmaa.bel.alcatel.be>...
> When a primary key is dropped , the space it occupied in the tablespace
>is no freeed.
>The segments become 'temporary' and get a name like '13.146412'...
>How can I force the system to free this space?
>The version of oracle '7.1.5'.
>
Received on Wed Jun 10 1998 - 09:25:36 CDT