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
I am using the same source .jsp file to create 2 html reports, one using 9i server and the other using 10g server. The report run on the 10g server has a double left margin compared with the report layout and the report run on 9i. When 10g report is [More]
My sympathies are with you, I just wished I had checked the Toshiba forums before making my purchase. I too have run into the non existence of their customer service. How on earth are you supposed to email Toshiba for some help. When I finally found [More]
Do any cases for the iPhone 4 fit the iPhone 4s and which are best. I really wanted the ifrogz soft gloss (not the phase) because it shows off the phone really well, but when I called to order it the reps said it didn't quite fit. They did say the gr [More]
I am getting the error "bean jspbean not found within scope error". I am using JBuilder 5.0. I thought that I had set up my paths and placed my code in the correct directories but it seems that I am missing something. I was developing in Visual [More]
Default display format is 01-JAN-09 for date picker. How can I change it to Jan 21, 2009 Thank you.If you need use your format for all data pickers in your application you can set it via: Go to Shared components ->Definition->Globalization (Tab) -&g [More]
Is there anything out there which will help me get a reasonably accurate estimate of time required to execute a portal project? I am not sure if generic software estimation tools based on use case analysis will calculate a realistic estimate. TIA, Ma [More]
hello : my system: win 7 64 ultimate inter core i7 3.5 16 GB ram AMD radeon HD 7900 3GB H.D.D SSD i installed after effects cs6 form Adobe CS6 Master Collection trial versigon. when i use CC particle World and go on optical map,and drawing on new gra [More]
Hi All, I have a search screen which will have 3 parameters as 2 input text field and 1 session value (login id). When user login into the application, i store the login id in session for further transaction in the application. Now in my search scree [More]
Hello Gurus, I have one requirement to Validate if the Header Text has been entered in one of the Text ID and if the same is blank I will have to make hard coded error message. Please provide me with the Table name or Structure name which holds the v [More]
Hi, After upgrade to SAP ME 5.2.5.5 the following type of errors occurs constantly. Any ideas how to get rid of it? Br, Johan #2.0 #2011 02 25 09:02:54:465#+0100#Error#com.sap.engine.services.servlets_jsp.ISE500# com.sap.ASJ.web.000500#BC-JAS-WEB#ser [More]