Solve the following error in init.ora:
ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0000255319C00040$$
sqlplus system
select owner, table_name, column_name
from dba_lobs
where segment_name = 'SYS_LOB0000255319C00040$$';
OWNER TABLE_NAME COLUMN_NAME
------------ ------------------- ------------------------
APPLSYS WF_NOTIFICATION_OUT "USER_DATA"."TEXT_LOB"
alter table applsys.WF_NOTIFICATION_OUT
modify lob ("USER_DATA"."TEXT_LOB") (STORAGE (MAXEXTENTS UNLIMITED));
Comments