Maxextents and LMTs
I got an alarm message this morning from our monitoring software:
DBSPI-0017.1: 1.00 segments are approaching maximum extents allowed in QAS.
NAME OWNER TABLESPACE TYPE EXTENTS MAX_EXTENTS
PPOPX SAPR3 PSAPBTABD TABLE 241 300
I tried this:
SQL> alter tablespace "SAPR3"."PPOPX" storage ( maxextents unlimited );
alter tablespace "SAPR3"."PPOPX" storage ( maxextents unlimited )
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option
Since PPOPX is an LMT how can I change the max-extents? Do I need to worry about max_extents?
Progress is made by lazy men looking for easier ways to do things -- Robert Heinlein