top of page
Search
Writer's picturemdvorkin

ORA-1693: max # extents 505 reached in lobsegment

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));

11 views0 comments

Recent Posts

See All

Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...

Comments


bottom of page