Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error: ORA-00604: error occurred at recursive SQL level 1 ORA-01654: unable to extend index SYS.I_PL

itzkashiMay 28 2015 — edited May 28 2015

hi ,

i am getting the below error while compiling the package .sometimes it is compiling succesfully but most of the time it throws an error.

Error report:

ORA-00604: error occurred at recursive SQL level 1

ORA-01654: unable to extend index SYS.I_PLSCOPE_SIG_ACTION$ by 128 in tablespace SYSAUX

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.

in dba_data_files autoextensilble is NO for sysaux and user tablespace.. is that the causing issue ??

please advise

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2015
Added on May 28 2015
6 comments
2,149 views