Re: How can i change the MAXEXTENTS ??

From: <JohannesBavendiek_at_gmx.de>
Date: Thu, 20 Aug 1998 11:56:17 GMT
Message-ID: <6rh2t1$2k8$1@nnrp1.dejanews.com>

In article <35DA6ECF.73F00544_at_exesolutions.com>, exe_at_exesolutions.com wrote:
> Madhu Cherukuri wrote:
>
> > Unfortunately you can not change the maxextents of a table
>
> This is not correct. The syntax for changing MAXEXTENTS is:
>
> ALTER TABLE schema_name.table_name STORAGE (MAXEXTENTS some_numeric_value);
>
> Regards,
>
> Daniel A. Morgan
>
>

But this will work only if the defined database-block-size value does allow it. The possible value of the maxextents end with this (physical) setting

db-blocksize - maximal maxextents-value

------------     ------------------------
   2K         -  121
   4K         -  249
   8K         -  505 or 504

Johannes Bavendiek

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 20 1998 - 06:56:17 CDT