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

ORA-16812: apply service not running on the apply instance recorded by the broker

QSM-02175: some query block in UNION ALL MV is not fast refreshable

ORA-00393: log string of thread string is needed for recovery of offline datafiles

QSM-00512: invalid summaries specified in the retention-list

IMP-00069: Could not convert to environment national character set's handle

ORA-21603: property id [string] is invalid

ORA-13619: The procedure argument string is greater than the maximum allowable length of string characters.

ORA-02803: Retrieval of current time failed

ORA-22287: invalid or modified directory occurred during string operation

AMD-00128: dimension #string: RDBMS parent column not specified

NNO-00607: server will forward to default forwarders only

ORA-12732: invalid interval value in regular expression

For more Oracle Errors Interview Questions Click Here