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

2 views0 comments

Recent Posts

See All

After logon trigger - trace user sessions

-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the conditions for activating trace -- SYS.XX_LOGIN_TRACED_SESSIONS - con

INCLUDE parameter of expdp

-- Export all public database links expdp user/password full=y \ include=db_link:"in (select db_link from dba_db_links where owner = 'PUBLIC')" -- Export one table expdp user/password include=table:"i

Multiplexing Redo Log and Control files

-- List redo log files select group#, member from v$logfile order by group#, member; -- Check redo log file status select group#, members, status from v$log; -- Adding redo log file to a group alter d