Analog ORA-01555

Analog ORA-01555

SQL> create undo tablespace undo_temp1 datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ ordb10 \ undo_temp1.dbf 'size 2 M autoextend OFF; tablespace created. SQL> alter system set undo_tablespace = 'undo _ temp1' scope = both; the system has changed. SQL> alter tablespace undo_temp offline; The tablespace has been changed. SQL> drop tablespace undo_temp including contents and datafiles; The tablespace has been deleted. SQL> show parameter undoNAME type value =----------- export undo_management string AUTOundo_retention integer 1undo_tablespace string undo_temp1SQL> create table test as select * from all_objects; SQL> variable x refcursorSQL exec> open: x for select * from test; PL/SQL is successfully completed. SQL> begin for I in 1 .. 10 loop delete from test where rownum <= 500; exit when SQL % rowcount = 0; commit; end loop; commit; insert into test select * from all_objects; commit; end loop; end;/PL/SQL process completed successfully. SQL> print xERROR: ORA-01555: Snapshot old: rollback field number 12 (name: "_ SYSSMU12 $") too small