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

> 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 Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown