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?

Thanks,
Vince