Originally Posted by
hrishy
Hi Mooks
I think there is something wrong with the date format set untli that part.thats why it ddi not mount.
can you please change the date part to
to_date('06-jul-2005 16:50:00','dd-mon-yyyy hh24:mi:ss')
regards
Hrishy
There was a bug (at least in 8.1.7 under Windoze) that prevented using to_date in the "set until" statement. I was obliged to set NLS_DATE_FORMAT in the environment and put the date as a string in the "set until". (Sorry, no refs, I'm on a desert island at the moment).
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Reply With Quote