top of page
Search

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

 
 
 

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...

 
 
 
Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...

 
 
 

Comments


bottom of page