Test Gestión de UNDO

1ª PREGUNTA: ¿QUÉ OCURRE SI UN SEGMENTO UNDO SE LLENA?

Otro segmento undo será creado automáticamente
El segmento undo se incrementa su tamaño automáticamente
El tablespace undo se extenderá, en caso de que sus datafiles estén configurados como autoextend
Las transacciones continuaran en un segmento undo diferente

Select * from scott.emp as of timestamp (systimestamp -1);
Insert into scott.emp (select from *scott.emp as of timestamp (systimestamp -1/24)minusselect * from scoot.emp);
Select * from scott.emp as of timestamp (systimestamp -1/1440);
Ninguna de las anteriores

Select * from scott.emp as of timestamp (systimestamp -1);
Insert into scott.emp (select from *scott.emp as of timestamp (systimestamp -1/24)minusselect * from scoot.emp);
Select * from scott.emp as of timestamp (systimestamp -1/1440);
Ninguna de las anteriores