Depends on your version of Oracle. If you are on 8.1.x, you can either set the maxextents to unlimited (ALTER TABLE xyz STORAGE (maxextents UNLIMITED);) or you could "move" the table with larger storage paramters (ALTER TABLE xyz MOVE TABLESPACE same_tbs STORAGE (INITIAL 8M next 8M MAXEXTENTS UNLIMITED);)
Originally posted by jlakhani
since number of extents is near max extents I am looking for guidance in what to do to make sure that I dont run out of extents.
would i wanna increase max extents or export then coalesce then import with new initial etc.?