Oracle: select from list of values

1	select distinct column_value from table(sys.odcinumberlist(1,1,2,3,3,4,4,5));

or

1	select column_value from table(sys.dbms_debug_vc2coll('One', 'Two', 'Three', 'Four'));

ORA-01555: snapshot too old: rollback segment number 61 with name "_SYSSMU61_1706556987$" too small

1 2 3

SQL> select max(maxquerylen) from v$undostat;   26687

Add 20% to this value and update UNDO_RETENTION parameter.

1	SQL> ALTER SYSTEM SET UNDO_RETENTION = 32024;