3 Replies Latest reply on Apr 18, 2014 12:21 PM by EdStevens

    ORA-01830: date format picture ends before converting entire input string

    2638616

      Could anyone help me out with this error . I know it is date mismatch format .

      I really need help.

      I can by pass this issue by using restore point but i really want to nail this one.

       

      TRYING TO PERFORM USER MANAGED INCOMPLETE RECOVERY USING UNTIL TIME

       

      nls_parameter in my system

       

      NLS_TIME_TZ_FORMAT
      HH.MI.SSXFF AM TZR

       

      NLS_TIMESTAMP_TZ_FORMAT
      DD-MON-RR HH.MI.SSXFF AM TZR

       

       

      SQL> SELECT SYSTIMESTAMP FROM DUAL;      

      SYSTIMESTAMP
      ---------------------------------------------------------------------------
      18-APR-14 01.22.17.291791 PM +05:30

       

      13:22:17 SQL> RECOVER DATABASE UNTIL TIME '18-APR-14 01.22.17.291791';

      ORA-01858: a non-numeric character was found where a numeric was expected

       

      13:23:55 SQL>  RECOVER DATABASE UNTIL TIME '18-04-14 01.22.17.291791 PM';

      ORA-01830: date format picture ends before converting entire input string

       

      COULD YOU POINT ME OUT WHERE I AM WRONG. PLZ

       

      THANKS