Posts Tagged ‘ORA-01552’

ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP’

April 15th, 2024, posted in Oracle Queries
Share
$ sqlplus / as sysdba
alter system set undo_management=auto scope=spfile;
2) Restart the database.
SQL> Shutdown immediate;
SQL> startup
Share