Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Increase FREEIST w/o drop objects

From: "Sinardy Xing" <SinardyXing@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 2 Oct 2004 15:05:15 +0800

Hi all,

Why Oracle said that to increase the FREELISTS you MUST RECREATE THE OBJECTS?

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

Follow-Ups:

Re: Increase FREEIST w/o drop objects
From: Tanel Põder

Other related posts:

RE: Increase FREEIST w/o drop objects

Re: Increase FREEIST w/o drop objects