SQL*Loader-350: Syntax error - found "TIMESTAMP"

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software
SQL*Loader-350: Syntax error - found "TIMESTAMP"

Software

Oracle 8i

Symptoms

When data is imported SQL Loader generates an error indicating incorrect syntax near TIMESTAMP

Action

The TIMESTAMP data type is available since Oracle 9i. If you are migrating to Oracle 8i, please specify this version in SQLWays and it will use the DATE data type instead of TIMESTAMP.