Oracle Database Administration: The Essential Refe

Data dictionary views

The following data dictionary views are used by the tablespace point-in-time recovery facility:

TS_PITR_CHECK

Identifies objects that will be impacted by the tablespace point-in-time recovery. As long as any items are included in this view, tablespace point-in-time recovery will fail. To query the view, use the following:

SELECT * FROM SYS.TS_PITR_CHECK 
WHERE (ts1_name IN recovery_set AND ts2_name NOT IN recovery_set) OR
      (ts1_name NOT IN recovery_set AND ts2_name IN recovery_set);

TS_PITR_OBJECTS_TO_BE_DROPPED

Lists objects created after the tablespace point-in-time recovery time. These objects will be dropped as part of the recovery process. You must make a copy of these objects prior to completing tablespace point-in-time recovery. If you don’t, the information in them will be lost.