Re: Max Extents Question

That what setting maxextents to "UNLIMITED" translates to. I think it's a good time for you to defrag your table.

Praveen

Kan Man wrote:
>
> Hello All.,
>
> We have a table A which has reached out max extents(2147483645)..One of
> our collegaues is saying that Oracle advise not to increase extents beyond
> this limit...
>
> I basically have two questions
> 1.Has Oracle advised for a maximum limit for max extents..?
> 2.If yes, what can we think of as a solution..?
>
> Thanks
> Kan
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --------
> Think you know someone who can answer the above question? Forward it to them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com

-- 
+===========================================================================+
|  Praveen K. Gautam                                                        |
|  Tellabs, Inc.                                                            |
+===========================================================================+