i'm trying to write a backup script that would recover until a specific time (incomplete recovery), when writing the set until command like:
set until time 'AUG-09-02 14:25:00';
i get ora-01830 date format picture ends before converting entire input string.
i added an entry in the registry (i'm in a windows 2000 box)-
NLS_Date_format 'dd/mm/yyyy HH24:MM:SI' but it seems that Oracle doesn't care about it, even if i use the same format in the set command.
what can i do?
Click Here to Expand Forum to Full Width