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-02275: such a referential constraint already exists in the table

1 Answers  


ORA-27500: inter-instance IPC error

1 Answers  


ORA-07825: sspsck: $QIO failure at AST level

1 Answers  


NCR-01012: NCRS: Receive message failure.

1 Answers  


ORA-16600: Failover operation can only be submitted at target database.

1 Answers  






ORA-13230: failed to create temporary table [string] during R-tree creation

1 Answers  


ORA-33004: (XSAGDNGL01) workspace object is not a relationship array.

1 Answers  


ORA-30940: Cannot resolve prefix 'string' for QName node 'string'

1 Answers  


ORA-09832: infoCallback: bad message format.

1 Answers  


ORA-25194: invalid COMPRESS prefix length value

1 Answers  


ORA-09799: File label retrieval failed.

1 Answers  


ORA-04083: invalid trigger variable 'string'

1 Answers  


Categories