Problem
Error report: ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.IDL_UB2$ by 128 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.
Validation
The tablespace SYSTEM is full. We can validate using the login `system` by the following SQL.
SELECT TABLESPACE_NAME , FILE_NAME , BYTES / 1024 / 1024 AS BYTES_MB , AUTOEXTENSIBLE , MAXBYTES / 1024 / 1024 AS MAXBYTES_MB FROM DBA_DATA_FILES;
If the `bytes` == `maxbytes`, then it is full.
Solution
This is how to extend the tablespace by manual.
ALTER DATABASE DATAFILE 'D:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' AUTOEXTEND ON NEXT 1M MAXSIZE 1024M;
Tips
How to shutdown oracle database
login sqlplus as sysdba
C : > sqlplus / as sysdba
shutdown
SQL > shutdown immediate
or startup
SQL > startup
Great….!
Thanks a lot
Thanks