Re: Help!! Max extents exceeded - Urgent

Joanna Lee wrote:
>
> Hi
>
> My company is using oracle version 6. My colleague encountered
> an error ora-01556 which says : max number of 40 extents exceeded. Can
> anybody tell me how big is the 40? is it 40M or 400M? I've increased the
> tablespace to 140M but to no avail. Can somebody help me? Thanks.
>
> Joanna

Hi,

the message means, that s.o. defined that there might only be 40 extends. The size of the 40th extend or the total size of all extends depends on the initial value and the defined percentage with wich every extend has grown. Look at the create script(s) to get these values.

-- 
Regards

M.Gresz    :-)