Fandom

How To Wiki

Oracle Applications HOWTO: modify LOB storage

1,795pages on
this wiki
Add New Page
Talk0 Share

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.

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

Also on Fandom

Random Wiki