Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Increase FREEIST w/o drop objects
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-lReceived on Sat Oct 02 2004 - 02:01:02 CDT
![]() |
![]() |