My Oracle Support Banner

Not Able To Import Database From Sybase DB To Oracle DB For Datetime/SMALLDATETIME (Doc ID 2510445.1)

Last updated on OCTOBER 04, 2019

Applies to:

Oracle SQL Developer - Version 18.4 and later
Information in this document applies to any platform.

Symptoms

 

When trying to import data from Sybase DB to Oracle DB. But for one of the table not able to import the data. One of the column in Sybase table is Datetime datatype but in Oracle we have only Date datatype. So while importing  getting below error.

"Data is not compatible with column definition"
"Insert failed for row 1 non numeric character found"


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.