Wikia

How To Wiki

Oracle Applications HOWTO: modify LOB storage

Talk0
1,814pages on
this wiki

Go to Michael Dvorkin's user page

Prerequisites Edit

E-Business Suite 11.5.9, 11.5.10


Steps to modify LOB storage Edit

1. Find the LOB owner according to the error from init.ora:

  ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOBXXXXXXXXXXXXXXXX$$
  sqlplus system/<system password>
  select owner, table_name, column_name 
    from dba_lobs 
   where segment_name = 'SYS_LOBXXXXXXXXXXXXXXXX$$';
  exit;

2. Modify LOB maxextents

  sqlplus system/<system password>
  alter table <OWNER>.<TABLE_NAME> modify lob (<COLUMN_NAME>) (STORAGE (MAXEXTENTS UNLIMITED));
  exit;

3. Example:

  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"
  sqlplus system
  alter table APPLSYS.WF_NOTIFICATION_OUT modify lob ("USER_DATA"."TEXT_LOB") (STORAGE (MAXEXTENTS UNLIMITED));


Known Issues Edit

Go to Michael Dvorkin's user page

Around Wikia's network

Random Wiki