Re: ORA 1556 maximum nuber of 99 extents allowed

Ravi,

The maximum number of extents is a function of your database blocksize. You can do an alter table to set it to a high value, but for a 2K block size, the maxmimum number of extents is 121. For 8K blocksize, the max is 505.

You will be better off making the SIZE of your extents bigger because the only way you can change the block size is to rebuild your entire db.

ALTER TABLE mytable
STORAGE (next 50M pctincrease 0)

This will make it so that all newly allocated extents are 50Meg. If your table already has a lot of extents (over 20 or so) you might as well rebuild it with the appropriate storage parameters.

Regards,
Charles_Dye_at_corp.dialog.com

In article <49d7da$31j_at_news.mountain.net>, vedula_at_Access.Mountain.Net (Ravi S. Vedula) writes:
> Hi
> I am having this problem after I load a lot of data into my table structure.
> The error message I get is ORA 1556 maximum nuber of 99 extents allowed
> .. I increased the extents size for most of the tables to a 1000 while some
> remained at 99 . Now I get the same error message
> but it says that 121 extents have been reached. I am not sure what I am doing
> wrong. I used the alter table to increase the extents. It disables my
> entire system . Has anyone had similar problems . I would appreciate
> any hints/help in this regard. Thanks
>
> Ravi
> vedula_at_rbse.mountain.net
>
> PS I am using ORACLE RDBMS V6.0.37.6.1 for SUNOS.
>
Received on Mon Nov 27 1995 - 00:00:00 CET