Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i change the MAXEXTENTS ??

Re: How can i change the MAXEXTENTS ??

From: Joel Garry <joelga_at_pebble.org>
Date: Thu, 20 Aug 1998 18:58:18 GMT
Message-Id: <slrn6tosg2.dqq.joelga@pebble.org>


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! Received on Thu Aug 20 1998 - 13:58:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US