Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> TSPITR
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