The following data dictionary views are used by the tablespace point-in-time recovery facility:
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
INrecovery_set
ANDts2_name
NOT INrecovery_set
) OR (ts1_name
NOT INrecovery_set
ANDts2_name
INrecovery_set
);
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.