Re: TEMP tablespace again

Hi!
First of all, you need drop your tablespace. Try drop tablespace temp (without clause including contents). As I see you can't drop tablespace.
After you drop it. You may create new.

Best regards.
Yroslav.
"Vadim Grepan" <kezal_at_mail.ru> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:3AAF318D.21C48D58_at_mail.ru...
> Hello!
>
> I have TEMP temporary tablespace with creating parameter ..MINIMUM
> EXTENT 32M
> DEFAULT STORAGE (INITIAL 32M NEXT 32M ..). So every session
> allocates
> 32M, it's too much. I'd like to decrease INITIAL/NEXT parameters and
> used clause
> alter tablespace temp default storage (initial 1M next 1M);
> Unfortunatly it doesn't work for some reason and sessions allocate 32M
> as usuall. After that
> I decided to re-create this space:
>
> ### 1. check for using tablespace:
> SQL> l
> 1 SELECT substr (s.username,1,10),
> 2 substr (u.tablespace,1,15), u.contents, u.extents, u.blocks
> 3 FROM v$session s, v$sort_usage u
> 4* WHERE s.saddr=u.session_addr
> SQL> /
> no rows selected
>
> ### 2. offline space
> SQL> alter tablespace temp offline;
>
> Tablespace altered.
>
> ### 3. drop space
> SQL> drop tablespace temp including contents;
> [..... wait a lot of time .....]
> ^Cdrop tablespace temp including contents
> *
> ERROR at line 1:
> ORA-01013: user requested cancel of current operation
>
> So how can I recreate/change parameter for this tempoprary tablespace?
>
> TFHAOT
>
> Rgds, Vadim Grepan
> ------------------------
> Moscow, Russia
>
>
>
>
>
Received on Wed Mar 14 2001 - 06:29:42 CST