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!

SQL Loader with BCP datetime format

1456768Jan 7 2015 — edited Jan 7 2015

Hi, Im having trouble while loading may data from sybase to oracle. I already have .dat for my target. however, its datetime column changed its format and it is not accepted to oracle.

please see below.

Source table

PUP_DATE

------------------

2014-10-01 10:34:07.613

PUP_DATE = datetime (sybase - source table)

target table data type for pup_date is TIMESTAMP

When my data from sybase is imported via bcp on .dat file the date format looked this way

.dat file

....

...

bcp command line generated from sql developer

bcp dbname.dbo.table_name out /directory/test.dat -c -t "<EOFD>" -r "<EORD>" -Usa -Ppassword -Sservername

What can i do to retain its format which is accepted to oracle?

I already tried modifying date and timestamp mask in sqldeveloper migration options. also the data type mapping from datatime to timestamp.

thanks!

This post has been answered by Barbara Boehmer on Jan 7 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2015

Added on Jan 7 2015

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

2 comments

1,659 views