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

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

Post New Answer

More Oracle Errors Interview Questions

ORA-24400: error occured while creating connections in the pool

1 Answers  


ORA-00972: identifier is too long

1 Answers  


TNS-12585: TNS:data truncation

1 Answers  


ORA-30110: syntax error at 'string'

1 Answers  


SQL*Loader-00257: TERMINATED BY EOF option not valid with ENCLOSED BY option

1 Answers  






ORA-22339: cannot alter to not final since its attribute column is substitutable

1 Answers  


PCB-00633: Invalid host variable and attribute pairing

1 Answers  


TNS-12663: Services required by client not available on the server

1 Answers  


ORA-30991: cannot use DOM to add special attribute to schema-based parent

1 Answers  


ORA-06132: NETTCP: access denied, wrong password

1 Answers  


ORA-26062: Can not continue from previous errors.

1 Answers  


ORA-29508: query derived from USING clause did not select a value of type string

1 Answers  


Categories