Posts

Showing posts from February, 2020

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

ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP_NEW’ I faced the above error while creating the explain plan for one of the table in database as shown below Create an explain plan for analysing to create an index duration & size SQL> explain plan for create index idx_tpay_recon_C_OCCURDATE on PAYMENT_NEW.T_REPORT(C_OCCURDATE); explain plan for create index idx_tpay_recon_C_OCCURDATE on PAYMENT_NEW.T_REPORT(C_OCCURDATE) * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP_NEW' Check the status of undo tablespace SQL> show parameter undo NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management string MANUAL undo_retention integer 900 undo_tablespace string UNDOTBS1 SQL> alter system set undo_management=auto scope=spfile; System altered