Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: recreate tablespace

Re: recreate tablespace

From: Titi <thierry.constant2_at_wanadoo.fr>
Date: Thu, 28 Feb 2002 21:25:49 +0100
Message-ID: <3c7e924d$0$8720$626a54ce@news.free.fr>


>
> For existing segments:
>
> spool doit.sql;
> SELECT 'ALTER TABLE ' || table_name || ' STORAGE (PCTINCREASE 0);' FROM
> USER_TABLES WHERE tablespace_name = 'FOO';
> spool off;
> @doit;
>
> The same applies to indexes.
>
> Uwe
>

Thanks for the answer,
Are you sure this statement modify the storage clause of EXISTING extents of the objects ???
or for the future extents of the objects ??

Thanks Received on Thu Feb 28 2002 - 14:25:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US