Re: Increase FREEIST w/o drop objects

> Why Oracle said that to increase the FREELISTS you MUST RECREATE THE
OBJECTS? Please reference, where is this stated?

This is from 9.2 RAC deployment doc:

"You cannot change the value of FREELIST GROUPS with the ALTER TABLE, ALTER CLUSTER, or ALTER INDEX statements unless you export, drop, rebuild, and reload the table. However, you can dynamically change the setting for the FREELISTS parameter with the ALTER TABLE, ALTER INDEX, or ALTER CLUSTER statements."

So, you can dynamically change freelists for a segment (they're just small pointers inside segment header). But if you want to change number of freelist groups using alter command, the whole contents of segment have to be physically copied to another location within an Oracle datafile, because Oracle wants to keep freelist group blocks right after segment header...

Tanel.

>
> How about just
>
> ALTER object_type object_name STORAGE (FREELISTS higher_value);
>
> or
>
> ALTER object_type object_name
> MOVE STORAGE (FREELIST higher_value FREELIST GROUPS
higher_ value);
>
> Thanks
> Sinardy
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l