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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1654 , Oracle asking for very large extent

Re: ORA-1654 , Oracle asking for very large extent

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 31 Jul 2006 16:57:10 -0700
Message-ID: <1154390230.344106.269270@s13g2000cwa.googlegroups.com> 





Brian Peasland wrote:


> > Could this be caused by specifying an upper limit for the number of

> > extents (MAX_EXTENTS) for the index?  8192 is 8KB.

>

> MAX_EXTENTS should be ignored for LMT's.

>

> Cheers,

> Brian




Brian, thanks for the correction.



Charles Hooper


PC Support Specialist


K&M Machine-Fabricating, Inc.
Received on Mon Jul 31 2006 - 18:57:10 CDT












Original text of this message













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