Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question: RMAN - Getting closer...
On Thu, 1 Sep 2005 21:48:40 +0200, BD wrote
(in article <1125604120.151442.257580_at_g43g2000cwa.googlegroups.com>):
> 4) RMAN: run {allocate auxiliary channel dev1 type disk;sql "alter
> session set nls_date_format=''MM-DD-YYYY HH24:MI:SS''"; recover
> tablespace small_tables_2 until time '09-01-2005 09:45:01';}
You could also have specified
recover tablespace small_tables_2 until time "to_date('09-01-2005
09:45:01','MM-DD-YYYY HH24:MI:SS')";
With kind regards / met vriendelijke groeten,
Ronald
http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle
Received on Fri Sep 02 2005 - 01:12:56 CDT