Oracle date migration

Simple solution that fully automates the process of data import, export or migration

Moderator: Support Team

Oracle date migration

Postby Vik » Tue Aug 09, 2011 9:49 am

When I try to migrate the same table to Oracle it retrieves:

ORA-01861: literal does not match format string

Please help.
Vik
 

Re: Oracle date migration

Postby Support Team » Tue Aug 09, 2011 11:13 am

Try to open settings window and select to_date function from "Apply date conversion function" drop-down menu.
Of course, you should correct date and/or time format if necessary. The predefined format is 'YYYY-MM-DD HH24:MI:SS'
Support Team
 
Posts: 253
Joined: Sun Mar 26, 2006 3:48 pm


Return to DTM Migration Kit

Who is online

Users browsing this forum: No registered users and 1 guest

cron