Duplicate database script truncates the time portion of set until time

From: Imtiaz Merchant <merchanti_at_hotmail.com>
Date: Mon, 24 Oct 2011 16:40:18 -0400
Message-ID: <BAY154-W26834E246A76F10FABE97FACEF0_at_phx.gbl>



I had a script that used to duplicate a prod database to a test environment up until the last known backup using the --> set until time "to_date('some date', 'dy Mon dd hh24:mi:ss yyyy')" option. This used to work fine until 10g, but after the upgrade to 11g, the time portion is somehow being chomped off and i'm left with a duplicate database being attempted until the previous day.

Any thoughts or inputs would be appreciated from the list.                                                

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 24 2011 - 15:40:18 CDT

Original text of this message