-
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?
Thanks,
Vince
-
ppopx is a table, not a tablespace
-
Bang head on door
Love Monday morning fires. Thanks for pointing out the obvious to me! Argh! :rolleyes: