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-15120: ASM file name 'string' does not begin with the ASM prefix character

ORA-16631: Operation requires shutdown of database/instance "string"

TNS-12219: TNS:missing community name from address in ADDRESS_LIST

ORA-09850: soacon: Archmon unable to lock named pipe.

ORA-25290: Cannot complete operation on queue string with existing messages

ORA-31447: cannot create change tables in the SYS schema

ORA-31621: error creating master process

QSM-02140: agg(expr) requires correspondng SUM(expr*expr) function

RMAN-06519: backup will never be obsolete

DRG-11605: URL store: document specified by string not found

ORA-12950: SYSTEM tablespace specified as default permanent tablespace

ORA-27062: could not find pending async I/Os

For more Oracle Errors Interview Questions Click Here