ORA-01841: (full) year must be between -4713 and +9999, and not be 0

ORA-01841: (full) year must be between -4713 and +9999, and
not be 0

Question Posted / guest

Answers were Sorted based on User's Feedback

ORA-01841: (full) year must be between -4713 and +9999, and not be 0..

Answer / puppala

Are you trying to load NULL values in records?

If so, can you do a "change all" to make the NULL values NOT NULL

Is This Answer Correct ?

0 Yes

0 No

ORA-01841: (full) year must be between -4713 and +9999, and not be 0..

Answer / guest

Cause: Illegal year entered

Action: Input year in the specified range

Please add more information about this Error

Is This Answer Correct ?

1 Yes

4 No

More Oracle Errors Interview Questions

LSX-00002: root element is not <schema>

LPX-00406: object of incorrect type passed to the function

RMAN-06086: offline files may only be skipped in a datafile backup set

ORA-38475: The attribute set and the associated ADT are out of sync.

NNL-00981: Timeouts, server not responding: number

ORA-14190: only one ENABLE/DISABLE ROW MOVEMENT clause can be specified

ORA-30158: The OCIFileWrite causes the file to exceed the maximum allowed size

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

ORA-12227: TNS:syntax error

TNS-12539: TNS:buffer over- or under-flow

ORA-32731: Another Parallel Oradebug session is in progress

ORA-25112: maximum number of BITMAP index columns is 30

For more Oracle Errors Interview Questions Click Here