Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert date types from mysql to oracle using Sql*Loader.

472609Mar 3 2006 — edited Mar 7 2006

I'm having a table in mysql which contain some date columns of data time type.I 'm migrating those data alone from mysql to oracle using the Sql*Loader.But in my oracle database the data colums are in "TimeStamp".While executing the script i'm getting the error like "Rejected - Error on table AS_PACKAGE, column INSTALLATION_TIME.
ORA-01843: not a valid month".IS there any changes in the CTL file i have to do before executing it.

Thanks,
Jai

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2006

Added on Mar 3 2006

#database-and-application-migrations

5 comments

1,327 views