ORA-01861: literal does not match format string



ORA-01861: literal does not match format string..

Answer / guest

Cause: Literals in the input must be the same length as
literals in the format string (with the exception of leading
whitespace). If the "FX" modifier has been toggled on, the
literal must match exactly, with no extra whitespace.

Action: Correct the format string to match the literal.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09243: smsget: error attaching to SGA

1 Answers  


RMAN-08029: snapshot controlfile name set to default value: string

1 Answers  


NZE-28768: bad magic number

1 Answers  


ORA-40273: invalid model type string for Adaptive Bayes Network algorithm

1 Answers  


ORA-15186: ASMLIB error function = [string], error = [string], mesg = [string]

1 Answers  






ORA-36702: (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.

1 Answers  


ORA-12171: TNS:could not resolve connect identifier: string

1 Answers  


ORA-00267: name of archived log file not needed

1 Answers  


ORA-02763: Unable to cancel at least one request

1 Answers  


ORA-14507: partition corrupt. all rows do not fall within partition bounds

1 Answers  


ORA-01511: error in renaming log/data files

1 Answers  


ORA-13200: internal error [string] in spatial indexing.

1 Answers  


Categories