Sitemap

Amicuk Programming Answers

Migration Issues from Informix to Oracle (datetime format)

-0001-11-30   Views:2

Advertisement

Hello, i am performing a Migration from Informix to Oracle, drive by Migration Workbench, i have an error migrating data from datetime and date fields. I suppose its related by datetime and date format, cause the error tells "Incorrect day or month&q

Hello, i am performing a Migration from Informix to Oracle, drive by Migration Workbench, i have an error migrating data from datetime and date fields. I suppose its related by datetime and date format, cause the error tells "Incorrect day or month" when i am migrating data from informix. Targets Oracle database date format is DD/MM/YYYY and source`s Informix database date format like MM/DD/YYYY. Is there any way, in OMW, to specify the mask of datetime or date format to convert date strings from informix to oracle format? Or have i got migrate offline and modify control file to do that with sql*loader?
How can i do that?
Example, especify to_date('....', 'MM/DD/YYYY H24:MI:SS') format for migrating informix datetime fields to Oracle.

The replay answer
Advertisement
The problem i have is, several tables witch contains date and datetime fields, at the same table in informix, by migrating drive by omwb to oracle, the date format i receive from informix at reading is DD/MM/YYYY and datetime format receiving is HH24:MI:SS. Migrating date and datetime types from informix to date, both types to date in oracle, i get an error while matching DD = HH24, MM = MI and YYYY = SS where nls_date_format is DD/MM/YYYY and, the same error matching HH24 = DD, MI = MM and SS = YYYY when nls_date_format is HH24:MI:SS.
If i set nls_date_format as "DD/MM/YYYY HH24:MI:SS" i get the same error, cause reading data from informix results in data format "DD/MM/YYYY" for date fields and "HH24:MI:SS" for datetime fields.
I have more than 200 tables in informix with this problem to migrate to oracle, i can solve by migrating offline, modifying datacontrol file to casting to_date format, but over 200 tables, 200 datacontrol files... is there any way for solving that by online migration in omwb?

Go to See the other 7 answers

Migration Issues from Informix to Oracle (datetime format)

Category:DefaultRelease time:-0001-11-30Views:130

Hello, i am performing a Migration from Informix to Oracle, drive by Migration Workbench, i have an error migrating data from datetime and date fields. I suppose its related by datetime and date format, cause the error tells "Incorrect day or month&q[More]

Migration issue sqlserver 2008 to oracle 11g

Category:DefaultRelease time:-0001-11-30Views:130

migration data from sqlserver to oracle at at thjat time i got issue, please give me a solution. error: migration actions have failes,check the migration reports for details;capture enterprise capture capture faild.refer to migrlog table inthe reposi[More]

Migrating Data from Informix to oracle

Category:DefaultRelease time:-0001-11-30Views:130

Is it advisable to migrate the whole schema from Informix database to Oracle 10g or migrate each table using sqlldr. If the data model is not exactly same then can we export data from informix and import the dump file in Oracle 10g.You can use Generi[More]

Migration from Informix to Oracle

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Could anybody share the case studies/plan/docs related to migrating data from Informix to Oracle.Hello, The Oracle® Migration Workbench Reference Guide for Informix Dynamic Server Migrations is avalaible at http://download.oracle.com/docs/html/B1[More]

Database migration informix to Oracle

Category:DefaultRelease time:-0001-11-30Views:130

Hello Could you tell me the technical improves of changes our Informix DB to Oracle. We have an SAP system with 800 GB over Informix and a good functionality and response time, therefore I´d like to know how Oracle could help us to increase this feat[More]

Informix to Oracle Migration

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, We have an application written in Informix 4gl and Esql/C which communicates with Informix database. We are doing an exercise of migrating this application from Informix to Oracle database. For compiling this, right now Hydra compiler is used[More]

After DB migration(Informix to Oracle), SQLs need to review & change?

Category:DefaultRelease time:-0001-11-30Views:130

Dear all, We migrate our system DB from Informix to Oracle 9i. The current problem is: All data in CHAR fields will have "SPACE". For example, There is a table named TABLE1, and one field named FIELD_1 in it. The type of FIELD_1 is CHAR, 4 chara[More]

Migrating SQL Server database to Oracle 8i - any known issues

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am in the process of migrating SQL Server database to Oracle 8i for testing purpose. When I do migrate SQL Server database to Oracle 8i, am I doing any harm to the exiting SQL Server database? Would the users be able to use SQL Server database[More]

Need profile option for determining DateTime format in Oracle Forms

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, I also have requirement where I need to read the date format in which Oracle Forms displays date values. As per updates to [this thread|https://forums.oracle.com/forums/thread.jspa?messageID=10285119] , I just need to read the profile opti[More]

MYSQL to ORACLE  blob migration issue

Category:DefaultRelease time:-0001-11-30Views:130

Hi I am currently migrating a mysql schema to Oracle. I have used the SQLDeveloper Migration Workbench to generate the scripts to capture the data and to upload the data to oracle. However I have an issue with one particular table (which contains blo[More]

Migrating data from Informix 7.2 to Oracle RDBMS

Category:DefaultRelease time:-0001-11-30Views:130

I've got several applications running on an Informix 7.2 database and I need to migrate this data to an Oracle 8.1.7.4 database. Is there a gateway product available to aid with getting this data migrated. We tried Oracle Migration Workbench but Info[More]

Hot
Hi, I have iPhone 5 through AT&T and today I got a message from AT&T that I've reached 65% of my data limit. When I went online and checked the data usage it is showing that I had been using my mobile data all this time whereas I was under impress [More]
I have a site that I put together for a charity..I have done it for a few years and the content, images etc don't change too often. Every month or so there needs to be an update to timetable and information. At the moment I do this with GoLive which [More]
Hello,  I posted a problem some month ago that discribed a problem with hibernation since I'd installed LabView8. The proble is still there. I hibernate my laptop and the longer I wait for waking up the machine again the longer it takes to wake up. I [More]
Is it possible to change the layout in terms of its shade, font colors and size of fonts?Here's a link for superfish menu jQuery http://plugins.jquery.com/superfish/ Here's a link explaining how to work with menu v2 http://helpx.adobe.com/business-ca [More]
Hello all. We have a problem when we try to execute a query in web. We developped queries via query designer and we published all in a role. By doing it system generates a link that makes possible to execte this query via web. The issue is that somet [More]
Hi, I want to do cluster database(oracle9i) to standalone database(oracle9i) kindly provide me the steps for the same. Thanx, amit [email protected]Hello Amit, Here is a good discussion link to how to do this: Convert RAC database to single instance [More]
Hi, How does one go about putting extra files on a DVD. I want the DVD to play the video normally when it is put in a DVD player, but I also want a Quicktime file to be stored on the DVD so it can be accessed on a computer. ThanksYou can build the vi [More]
When using LabView PDA module to build an application for a PDA target, I receive the following message: "Error building executable. Unable to create file". Why is this happening? When looking at the error log, it reads "The system cannot f [More]
I Was adding another image to my work on photoshop touch, when the program froze. I cannot seem to correct this problem. I am using iPad.There is feature that allow you to see the layer in 3D but if you don't click on the X right way it will not let [More]
Help! I have used Time Machine to go back and retrieve my iDVD after trashing it and it still doesn't work. I looked at the CDs that came with my MacBook and I can't seem to find the file to reinstall iDVD. All the other discussions say that I should [More]