Database Software

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!

Load from SQLServer Datetime to Timestamp in Oracle using SQL Loader

Ashique RaheemMar 9 2017 — edited Mar 23 2017

Hi Guys,

DB running 11.2.0.4 on Unix environment. I have searched all over and couldn't find what I was looking for. So, I thought of creating this and please do point me if any similar threads have already been questioned.

I am trying to load datetime from SQL Server to Oracle. the Datetime format is as 2016-02-16 15:39:22.000

I have created the table on Oracle with column

SignatureTime timestamp

on control file I'm trying to load as

SIGNATURETIME "TO_TIMESTAMP(SUBSTR(:SIGNATURETIME,1, 19),'DD-MON-YYYY HH24:MI:SS')",

But I get this error

Record 1: Rejected - Error on table JOB.

ORA-00604: error occurred at recursive SQL level 1

ORA-01843: not a valid month

Please help

Thanks,

Ashique

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2017

Added on Mar 9 2017

#database-key-features, #export-import-sql-loader-external-tables

2 comments

2,072 views