Re: Help!! Max extents exceeded - Urgent

The maxextents refers to the maximun number of extents a table can have and has nothing to do with the size of the tablespace. Under version 7 the syntax to fix your problem would be;

alter table <table_name> storage (maxextents 100);

where 100 represents the allowable number of extents. The maximum value of this changes with the database block size but 100 would seem to be OK for now. Actually as you have already got 40 extents it may also be worth changing the size of the next extent, by including NEXT nK in the storage clause where n is the size of the next exent in k.

You can examine these values for all of your tables by typing;

select table_name,initial_extent,next_extent,max_extents from user_tables;

Apologies if this syntax is not correct under v6, but if not, at least it should give you some idea where to look in your v6 manuals.

Regards,

Ian Received on Wed Nov 05 1997 - 00:00:00 CST