Objects Lost after TSPITR

When TSPITR is performed on a tablespace the objects created after the recovery time will be lost. To view the objects that will be lost use the following query,

SQL> Select owner, name, Tablespace_name,
to_char(creation_time, ‘YYYY-MM-DD:HH24:MI:SS’)
From TS_PITR_OBJECTS_TO_BE_DROPPED
Where Tablespace_name in (‘SCOTT’)
And creation_time > TO_DATE(’01-JAN-09:07:05:15’,’YY-MON-DD:HH24:MI:SS’);


Thanks