DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01693 max # extents (string) reached in lob segment

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    ORA-01693 max # extents (string) reached in lob segment

    Hello all...

    Iam trying to load data (appox 1.5 G) into Oracle 8.1.7 DB using a 3rd party tool. All Tables are created during Data Loading time.

    Everything is going great , i had 2 datafiles where the data is getting loaded with both datafiles under AUTOEXTEND Mode...

    One of the tables OUTMAIL has large Data ( Appox 800MB). Iam Getting this error message on the screen,
    ________________________________________________________________

    The exact error I am getting is: ORA-1693: max # extents 4096 reached in lobsegment LYS.SYS_LOB0000145096C00007$$
    _________________________________________________________________

    Oracle Document days :

    ORA-01693 max # extents (string) reached in lob segment string.string

    Cause: A LOB segment tried to extend past MAXEXTENTS.

    Action: If MAXEXTENTS is less than the system max, raise it. Otherwise, you must re-create with larger initial, next or PCTINCREASE parameters.
    ________________________________________________________________


    My questions are

    1) Based on Oracle Doc Solution, How do we Increase the MAXEXTENTS so that they are not less than System max ? How do we find out System Extents ?... How do we do this thru OEM ?...

    2) Can we increase EXTENTS during Data Import ?....


    Thanks for all your help

    Ron

  2. #2
    Join Date
    May 2001
    Posts
    736
    Check this DOC ID : 1014040.102 on Metalink

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width