Automic Workload Automation

  • 1.  ORA-01692 Unable to extend lob segment

    Posted Feb 17, 2017 04:02 AM
    You Asked

    What is causing this?

    and we said …

    ORA-01691: unable to extend lob segment %s.%s by %s in tablespace %s   

    Cause: Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.   

    Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
     
    In this case of an ORA-01691 error, the solution is to identify the name of the tablespace associated with the LOB segment and add space to the tablespace using the "alter tablespace *** add datafile yyy size zzz".


  • 2.  ORA-01692 Unable to extend lob segment

    Posted Feb 20, 2017 05:25 AM
    A next step would be to check if the database reorganization is done correctly to prevent data tables from growing extensively.