Quote:
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.?
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);)