ORA-01862: the numeric value does not match the length of
the format item



ORA-01862: the numeric value does not match the length of the format item..

Answer / guest

Cause: When the FX and FM format codes are specified for an
input date, then the number of digits must be exactly the
number specified by the format code. For example, 9 will not
match the format specifier DD but 09 will.

Action: Correct the input date or turn off the FX or FM
format specifier in the format string.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06140: cannot specify TAG option with LIST INCARNATION

1 Answers  


ORA-27546: Oracle compiled against IPC interface version string.string found version string.string

1 Answers  


ORA-09794: szrbuild: length of role name is greater than buffer.

1 Answers  


ORA-00271: there are no logs that need archiving

1 Answers  


ORA-13008: the specified date format has an invalid component

1 Answers  






ORA-00200: controlfile could not be created

1 Answers  


ORA-09205: sfqio: error reading or writing to disk

1 Answers  


NID-00397: Changing database name from string to string

1 Answers  


ORA-16641: failure to acquire broker configuration metadata lock

1 Answers  


NNO-00155: warning: hint number has missing address, hint ignored

1 Answers  


NNC-00425: meta-data violation

1 Answers  


RMAN-06719: file "string" (string bytes) restrieved from catalog

1 Answers  


Categories