Wednesday, March 23, 2005

alert in db13 with maxextents

table name: catm 300 to 350

if you are almost reached maxetextents of a table, you have to reorganize it to increase maxextents parameter. also if your table is growing faster, you may think to increase next extent size of this table. to do this: 1. start SAPDBA 2. select d-reorganization menu 3. select b-table/index reorg. 4. follow the instuctions and give your table name to increase next extent and maxextent parameters

posted by Dali @ 4:52 PM