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

PCB-00629: Host variable is not of Internal LOB type

NNL-00349: Configuration will be saved in string

ORA-36669: (XSDPART07) string is not a legal LIST partition.

ORA-28530: Heterogeneous Services initialization error in NLS language ID

ORA-30479: Summary Advisor error string

ORA-24281: invalid access past the maximum size of LOB parameter string

ORA-30132: invalid key index supplied

ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

ORA-13183: unsupported geometric type for geometry string.string

RMAN-08035: partial resync skipped, target database not mounted

TNS-00294: Connection Manager: Security is enabled, you cannot STOP the Interchange

ORA-02064: distributed operation not supported

For more Oracle Errors Interview Questions Click Here