Re: recreate tablespace

Titi wrote:
>
> Hi,
>
> What is the easiest way to recreate a tablespace with PCTINCREASE = 0 ?
> Thanks ...
>

For new segments:
ALTER TABLESPACE foo DEFAULT STORAGE (PCTINCREASE 0);

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

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!