--------------------------------------------------------------------
In the above script you can find the schema, which is nearing to maxextent, So you have to increase the Maxextents.

To increase the Maxextents, you can run the following script:
Assume: ext_used:63, Max_extent 70
--------------------------------------------------------------
ALTER . STORAGE (MAXEXTENTS 80)
---------------------------------------------------------------

Hope this will help you...

Anandharaj

06-08-2001, 09:05 AM

anandharaj

Hi Fiona

To increase the Maxextents, you can run the following script:
Assume: ext_used:63, Max_extent 70
--------------------------------------------------------------
ALTER segmenttype schema.tablename
STORAGE (MAXEXTENTS 80)
---------------------------------------------------------------