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

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2004