Temp Tablespace In Local Managed
I am running Oracle 18.104.22.168.0 and now I am upgrading to 22.214.171.124.0. Everything went well till I ran the catalog.sql,catproc.sql and I got some error something about "ORA-03212: Temporary Segment cannot be created in locally-managed tablespace"
Any way, when my upgrade completed, I look into any objects belong to SYS or SYSTEM that were INVALID and I got the punch of them. SO I tried to run the UTLRP.SQL scripts to compile those INVALID objects and I got the below errors:
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_SQL
ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 44
Have anyone encountered this problems???