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
select sal, case sal when 500 then 'low' when 5000 then 'high' else 'medium' end case from emp; OUTPUT sal    case 4587 medium 5000 high .....so  can i have range in the place of  case  at output?select nvl(sal,0) sal, case when nvl(sal,0)<=500 then [More]
Hi, my MacBook Pro battery life has been really dying quickly in the past couple weeks. My MacBook Pro is new as of December, and has only gone through 107 cycles. I am only running Chrome and Microsoft Word and a couple of other applications (Mail a [More]
My iMac no longer will get FaceTime to connect with others. Howecer, my FaceTime on my iPad works perfectly. Ideas?My iMac no longer will get FaceTime to connect with others. Howecer, my FaceTime on my iPad works perfectly. Ideas?Read other 8 answers [More]
hello I am not sure why but my mouse cursor keeps stopping for a part of a second every 10 seconds or so. I know this may not seem bad but it gets kind of annoying because I play a lot of games and when the cursor stops even for a split second it mes [More]
Hi ALL      I am working on Check print using f110_prenum_chck. The problam is  that if the  invoice line item overflow to next page then the first page should be considered as first check and it should not get voided. the remaining pages, check shou [More]
To evaluate the expression the code is: protected Object evalEL(DataActionContext ctx, String expression ) { Evaluator eval = Evaluator.getEvaluator(ctx); return eval.getValue(expression); String customerName = (String)evalEL(ctx,"${bindings.CustName [More]
This afternoon I switched from Embarq DSL to Comcast. My Airport Extreme is connected to my new cable modem. We tested the Internet connection, both wirelessly and via Ethernet, with my Macbook Pro before the tech left. We also tested the MBP connect [More]
I want to load data into table using SQL LOADER. Challenge I am facing is fields are separated either by ',' or '.' Eg:x0,y0,z0,a0.b0.c0.d0,p1,q1,r1 x1,y1,z1,a1.b1.c1,p1,q1 ie, the whole field, which contain '.' can be a join of any numebr of fields [More]
I have reported this bug since always, you guys graduated a new version and the bug is still there: Remains the issues with Win7 superbar | Nokia Beta Labs http://betalabs.nokia.com/apps/nokia-ovi-suite-3-0-private-alpha/bugreport/15311/remains-the-i [More]
Hi All,       I am new to ESS/MSS .. i am familiar with webdynpro .i have to customize some standard ESS webdynpro applications .. Can some one tell me what all i need to know .    Firstly can some one tell me what exactly a infotype is ?? and what i [More]