That can't be true since you can set the max extents to unlimited.
Glen
JohannesBavendiek_at_gmx.de wrote:
>
> 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 - 09:36:50 CDT
