ORA-01632: max # extents (505) reached in index APPLSYS.SYS_IOT_TOP_217479
Find primary storage for SYS_IOT_TOP_217479 by command.
SQL> select owner, table_name, table_type from dba_indexes where index_name = 'SYS_IOT_TOP_217479';
OWNER TABLE_NAME TABLE_TYPE
------------------------------ ------------------------------ -----------
APPLSYS AQ$_WF_JAVA_DEFERRED_T TABLE
After you get primany storage.
Extend that storage with this command:
alter table APPLSYS.AQ$_WF_JAVA_DEFERRED_T storage(maxextents unlimited);
** If TABLE_TYPE is INDEX. Change "alter table" to "alter index"