TSPITR

From: <junlei_at_my-deja.com>
Date: Tue, 16 Nov 1999 16:18:40 GMT
Message-ID: <80s04p$5e5$1@nnrp1.deja.com>

Has anyone used TSPITR?

I am not quite clear about the time parameter when querying TS_PITR_OBJECTS_TO_BE_DROPPED. The example given in the Oracle 8 Backup and Recovery Guide is as follows:

With a recovery set consisting of TS1 and TS2, and recovery point in time of '1997-06-02:07:03:11', you should issue the following query:

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 ('TS1', 'TS2') and
creation_time > to_date('97-JUN-02:07:03:11', 'YY-MON-DD:HH24:MI:SS') order by tablespace_name, creation_time;

Can anyone tell me what the to_char time and the second half of the to_date time are?

Thanks.

Junlei

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 10:18:40 CST