Re: Help!! Max extents exceeded - Urgent

The 40 extents is a value your long-ago DBA provided as a ceiling for your table.
The size of each extent is dependent on the initial extent size, next extent size and %increase value defined for the table. You're only allowed up to 121 extents. As you've discovered, simply adding a new tablespace file isn't enough; you have to let the table use it by increasing the number of extents allowed (not necessarily allocated). You can increase the number of allowable extents with: alter table storage (maxextents 121);
Or whatever number larger than 40 you wish, not to exceed 121. This is what you need to do to get back up and running quickly. For the long haul, you should export the table, drop it and recreate it with storage parameters that will result it fewer extents. I would strongly urge you to move up to 7.x because 6 is no longer supported.

Joanna Lee <joanna_at_scotts.com.sg> wrote in article <345F0114.BDE24305_at_scotts.com.sg>...
> 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.
Received on Tue Nov 04 1997 - 00:00:00 CST