Re: How can i change the MAXEXTENTS ??

From: <jtesta_at_my-dejanews.com>
Date: Fri, 07 Aug 1998 12:45:29 GMT
Message-ID: <6qest9$oa1$1@nnrp1.dejanews.com>

Depending on your version, you can have unlimited extents, but if you already have 121, you might want to consider, rebuilding that table(hint export/import) to cut down on the number of extents.

joe
http://www.oracle-dba.com

In article <6qcofc$vtp$1_at_nnrp1.dejanews.com>, ashesh48_at_my-dejanews.com wrote:
> Hi All, I got into the problem with the MAXEXTENTS of the table. It has
> reached to its maxlevel of the 121/121. How can I increase it?? Has anybody
> know the syntex for it ? How it affects to performace? And what is the
> recommanded number oof extents for a table??
>
> Thanx for any help in advance.
> Ashesh
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 07 1998 - 07:45:29 CDT