top of page
Search

ORA-1693: max # extents 505 reached in lobsegment

Writer's picture: mdvorkinmdvorkin

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

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

Cancelled scheduled concurrent requests

This SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for...

Foreign key constraint violation

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

Comentários


bottom of page