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

Home -> Community -> Mailing Lists -> Oracle-L -> Increase FREEIST w/o drop objects

Increase FREEIST w/o drop objects

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Sat, 2 Oct 2004 15:05:15 +0800
Message-ID: <7534CC34CD1D9F49BB05A00B9C6F20F4016BC73C@antares.bcsgroup.com.sg>


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
Received on Sat Oct 02 2004 - 02:01:02 CDT

Original text of this message

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