7 pages found, pages 1 to 7
http://www.freelists.org/post/oracle-l/Erghbanging-head-against-a-wall-here-sqlplusrecoveruntil-timesysdate,1    Similar Pages
... until time to_char(sysdate,’YYYY-DD-MM:HH24:MI:SS’)-5/1440; ORA-00285: TIME not given as a string constant ... -0400 Can you store sysdate as a varchar string earlier in the program? a little PL/SQL block in your ... backup controlfile until time ‘to_char(sysdate,’YYYY-DD-MM:HH24:MI:SS’)-5/1440’; ORA-01841: (full) year must ...
http://www.freelists.org/post/oracle-l/Erghbanging-head-against-a-wall-here-sqlplusrecoveruntil-timesysdate,5    Similar Pages
... until time > to_char(sysdate,’YYYY-DD-MM:HH24:MI:SS’)-5/1440; > > ORA-00285: TIME not given as a string ... until time > ‘’to_char(sysdate,’YYYY-DD-MM:HH24:MI:SS’)-5/1440’’; > > ORA-01840: input value not long ... string constant > > > > I’ve tried: > > SQL> recover database using backup controlfile until time > ‘to_ ...
http://www.freelists.org/post/oracle-l/cross-node-restore,5    Similar Pages
... ORA-00285: TIME not given as a string constant SQL> recover database until cancel using backup controlfile; ... but I believe this means it wants a string 'xxx' and you gave it a date. Joel Patterson Database Ad ... until time to_date('07-21-2009 20:00:00','mm-dd-yyyy hh24:mi:ss') using backup controlfile; ORA-00285: ...
http://www.riddle.ru/mirrors/oracledocs/server/msg73/ch203.html    Similar Pages
... action. ORA-00285 TIME not given as a string constant Cause: UNTIL TIME was not followed by a string constant ... Action: Use a shorter string, making sure not to exceed the given limit and try again. ORA-00254 error ... but do not enter a new log name. ORA-00268 specified log file does not exist name Cause: The given redo ...
http://www.cs.umbc.edu/help/oracle8/server.815/a67785/e0.htm    Similar Pages
... action. ORA-00285 TIME not given as a string constant Cause: UNTIL TIME was not followed by a string constant ... command. ORA-00269 specified log file is part of thread string not string Cause: The given redo log file ... Choose a value as indicated by the message. ORA-00097 use of Oracle SQL feature not in SQL92 string Level ...
http://www.databaseskill.com/2192924/    Similar Pages
... session still in progress ORA-00285: TIME not given as a string constant ORA-00286: no available members ... feature is not supported; logon denied ORA-01005: not given a password; logon denied ORA-01006: bind ... process in a given context ORA-01049: current RPC does not support the assignment by name ORA-01050: can ...
http://www.databaseskill.com/672190/    Similar Pages
... session still in progress ORA-00285: TIME not given as a string constant ORA-00286: no available members ... feature is not supported; logon denied ORA-01005: not given a password; logon denied ORA-01006: bind ... process in a given context ORA-01049: current RPC does not support the assignment by name ORA-01050: can ...