CODEWITHSUNDEEP
oracle-database
user10414478
user10414478

Reputation: 5

ORA-01654: unable to extend index SYS.I_IDL_UB11 by 8 in tablespace SYSTEM 00604. 00000 - "error occurred at recursive SQL level %s"

ORA-00604: error occurred at recursive SQL level 1

ORA-01654: unable to extend index SYS.I_IDL_UB11 by 8 in tablespace SYSTEM
00604. 00000 -  "error occurred at recursive SQL level %s"

*Cause:    An error occurred while processing a recursive SQL statement
           (a statement applying to internal dictionary tables).
*Action:   If the situation described in the next error on the stack
           can be corrected, do so; otherwise contact Oracle Support.

for the below program

CREATE OR REPLACE PROCEDURE add_job(a VARCHAR2) IS
BEGIN
    DBMS_OUTPUT.PUT_LINE('HELLO '||a);
END;
/

Upvotes: 0

Views: 3396

Answers (1)

Martin Preiss
Martin Preiss

Reputation: 396

looks as if your SYSTEM tablespace has not enough space to extend the index segment. I would take a look at dba_data_files and compare blocks, maxblocks, user_blocks for the system tablespace, and check the value for AUTOEXTENSIBLE.

Since there is not much you can do to shrink the SYSTEM tablespace (apart from maybe get rid of audit data) usually a massive growth of the SYSTEM tablespace indicates a problem (maybe indeed some user objects in the tablespace).

Upvotes: 1

Related Questions