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

Home -> Community -> Mailing Lists -> Oracle-L -> Which free extent will my table use next time?

Which free extent will my table use next time?

From: Liu Jane-TJMU-A13624 <A13624_at_Tianjin.mot.com>
Date: Thu, 22 Jun 2000 15:14:07 +0800
Message-Id: <10536.110108@fatcity.com> 





Hi all,



1.There are 3 free extents in one tablespace, 100M/10M/2M bytes,
2. A table resides in this tablespace is going to allocate a 1M extent.



Is it possible to force the table to use certain free extent (maybe the 
smallest one:2M ) ?  Really want to keep the big extents for other segments.





Thanks,
Received on Thu Jun 22 2000 - 02:14:07 CDT












Original text of this message













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