Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01555: snapshot too old: rollback segment number 6 with name "_SYSSMU6_$" too small

0614Mar 3 2021

Hi Folks,
Using Oracle database - 19C DB
Taking table snapshot at the first second of every hour, getting the ORA-01555: snapshot too old issue,
Below is the undo_retention size
undo_retention integer 600

below is the code used in the procedure
insert into t_emp_log
select *
FROM emp AS OF TIMESTAMP v_timstamp emp;

Could you please check and do the needful?

This post has been answered by EdStevens on Mar 3 2021

Jump to Answer

Added on Mar 3 2021

#dba, #general-database-discussions, #oracle, #plsql, #sql

1 comment

445 views