Re: ORA 1556 maximum nuber of 99 extents allowed

Even though you set this parameter to 1000, the actual value used is O.S. dependant, I know for HP-UX it is 122. To solve this problem, you have to export your table with compress extents option and import it back after dropping. You should also set the NEXT parameter to a bigger value so that this problem will not happen frequently.

Bhasker Ravikanti.

Ravi S. Vedula (vedula_at_Access.Mountain.Net) 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.
>

--
E-Mail:ag850_at_Freenet.Carleton.CA