Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: recreate tablespace
>
> 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