1 Reply Latest reply on May 20, 2016 6:59 PM by Srini Chavali-Oracle

    ORA-55526: temporary tablespace to store temporary undo not available

    user12198680

      We upgraded our 11gr2 DB to 12c. Now if we set parameter alter system set temp_undo_enabled=TRUE;


      We get alert in the alert log as ORA-55526: temporary tablespace to store temporary undo not available and many things fail. Even adpatch fails. What temporary table setting shall be done to keep this parameter true and not get this error?


      THanks