Re: How can i change the MAXEXTENTS ??

Sorry, my information was for Version before 7.3. Thx.
Johannes

In article <slrn6tosg2.dqq.joelga_at_pebble.org>,   joelga_at_nospam.pebble.org wrote:
> On Thu, 20 Aug 1998 07:36:50 -0700, Glen Upreti <glen.upreti_at_nau.edu> wrote:
> >That can't be true since you can set the max extents to unlimited.
> >Glen
>
> Depends on the version.
>
> >
> >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
>
> --
> These opinions are my own and not necessarily those of Information Quest or
> Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com
> http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply.
> mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA!
>

-----== 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 21 1998 - 02:54:43 CDT