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

RMAN-20029: cannot make a snapshot controlfile

QSM-02004: grouping column omitted from SELECT list

NNL-00932: Requests refused, type syntax mismatch: number

TNS-01014: set|show log_{ } [<value>]: set|show log parameters of current listener

NNL-01003: NON LEAF responses received: number

NZE-29013: SSL MAC verification failure

ORA-16058: standby database instance is not mounted

LSX-00016: schema and instance document have incompatible character sets

ORA-36874: (XSFTDSC04) Expression string cannot be used to define a column in a LIMITMAP.

ORA-07392: sftcls: fclose error, unable to close text file.

ORA-16740: log transport service for standby "string" incorrectly set to ALTERNATE.

TNS-04013: CMCTL timed out waiting for Oracle Connection Manager to start

For more Oracle Errors Interview Questions Click Here