ORA-1654: unable to extend index SAP_U1 by 130 in tablespace IDXTB

Posted on 2004-11-02
Last Modified: 2007-12-19

In error message

ORA-1654: unable to extend index SAP_U1 by 130 in tablespace IDXTB,

what does 130 means here, 130 bytes?

Question by:ebi168

    Assisted Solution

    are you using oracle 8i?

    this is an out of space error- the system cannot get more extents for your index.
    - check your temp tablespace using v$tempspace.maybe temp tablespace not big may need to increase it
    - you may also want to check the size of your tablespace and increase this also
    - check your system tablespace, and you may need to increase this also. if system tablespace is insufficient even if the object's tblespace is ok, will still not work.
    - check MAX_EXTENTS or MAXEXTENTS (I think this depends on your version of oracle). This is the set maximum number of extents. you can change this parameter associated with your object.

    hope that helps : )

    LVL 2

    Accepted Solution


    130 is the number of blocks that Oracle is missing to extend your tablespace IDXTB.
    Nothing to do with bytes. You may wish to extend your tablespace like this by adding for example a datafile:

      ADD DATAFILE ....

    Plse, see your doc for syntax specifics.

    Author Comment

    Thanks for the information. One more question is that during data loading, oracle looks for one extent, then another,..., when it comes to the point it couldn't find another extent, it fails. By then it calculate and get that 130 blocks are missing. It is not like at the beginning of loading, it knows the problem and hauls. Am I right?

    Author Comment

    In this case, are those data fit into the storage loaded into the table?
    LVL 2

    Expert Comment

    Hi ebi168,
    If i understand you correctly, you think Oracle despite the lack of space will
    store the data in the available space and report an error with regard to the missing blocks. I'm afraid it doesn't work that way. I am confident Oracle will not add _any_ data in the table if space requirements are not met.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now