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 Gurus I am looking for a way to allow the sent mails to be seen and viewed in the Call center agents inbox on the Web UI. We are using EHP1 is the above mention possible for us? Many Thanks in Advance VikasWhat about sending them to himself as BCC [More]
Every once in a while, Preview will find a JPG that, after I edit it, it will decide it should destroy on a save--it nulls out the file, keeping a lock on it (I cannot overwrite the file even if I close Preview). It's consistent with the file--if it [More]
I have had some significant issues with Adobe Illustrator and Indesign CC over the past week.  Previous to this I had no issues.  Now, each time I run the programs and place an image, they will crash the moment I try to move the placed image.  I am r [More]
I have placed my footer image and used Tile horizontaly in the master page. It previews correctly in the browser from master page, but not from the other pages. But when it previews or exports with the different pages, it is not showing as it suppose [More]
Hi, Oracle Enterprise Manager 10g (OEM) seems to indicate incorrectly the status of the database instance/the agent connection in windows 2003. I was able to connect and manipulate oracle database using SQLPlus/SQL Developer, but the OEM kept indicat [More]
When i connect to iTunes it says that i have enter my passcode to go in, but i have forgotten my passcode, and the power button is not worrking, is their any other way to do it without the computer or any other internet stuff or stores,No. You need a [More]
Hi, I was wondering if webi reporting allows us to implement hover functionality wherein if we choose to hover over particular row it shows the column value that we want to display when the users hover. The reason for analyzing this requirement is be [More]
i have problem with my mic when i make call the others cannot hear me but the mic is ok i checked it out and it works dont know what to do help me !!Hello Sabbir Khan, Thanks for using Apple Support Communities. For more information on this, take a l [More]
Dear all, When we try to open the SCO console , we are getting below error. [httpWebRequest_WebException_RemoteServer] Arguments: NotFound Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagn [More]
Hi experts, I am writing a diploma-thesis regarding load-testing on XI. To my knowledge, XI will need a database for e.g. persistency management or archiving messages. Therefore XI won't work without a database... I am looking for an official SAP doc [More]