We have a problem today wherein in Oracle we are trying to execute a package (every morning) and this is the only time we encountered the error (ORA-0114).
Any ideas how to fix this? We have already extended the SYSTEM and TEMP tablespace space.
And the crazy thing is, we tried yesterday and recompiled the package (we are using TOAD) and it worked. But today, it didn't work again even though it was already recompiled (same error).
BTW, line 273 was the part INSERT INTO SELECT statement.
I tried to execute the SELECT statement on the query window, and it also gets the same error.