Skip to main content
Announcements
Marching toward a simplified navigation! READ ON

ORA-01801: date format is too long for internal buffer

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
SachinB
Support
Support

ORA-01801: date format is too long for internal buffer

Last Update:

May 30, 2022 4:47:00 AM

Updated By:

Sonja_Bauernfeind

Created date:

May 11, 2021 3:18:00 AM

Replicate Error for oracle source endpoint:

ORA-01801: date format is too long for internal buffer.

 

Cause 

The date format string was too long to process. This should occur only if several long literals are specified as part of the date at the source.

 

Resolution

Remove long literals from the date format string.

Identify the exact record which is causing the issue on the database side by, fo example using cqlplus utility to scan a particular column.

 

Related Content 

ORA-12899: value too large for column 

 

 

Environment

 

 

 

Labels (1)
Version history
Last update:
‎2022-05-30 04:47 AM
Updated by: