MySQL Import data into Oracle

MySQL imports data into Oracle.

To build an Oracle table:

CREATE TABLE"Gg_user" ("USERID"VARCHAR2(255BYTE) not NULL, "Ispart"VARCHAR2(255BYTE)DEFAULT NULL, "Actualpositionid" Number( One)DEFAULT NULL, "Beginworktime"TIMESTAMP(0)DEFAULT NULL, "BIRTHDAY"TIMESTAMP(0)DEFAULT NULL, "Cardno"VARCHAR2(255BYTE)DEFAULT NULL, "EMAIL"VARCHAR2(255BYTE)DEFAULT NULL, "Genderid" Number( One)DEFAULT NULL, "Healthid" Number( One)DEFAULT NULL, "HOME"VARCHAR2(255BYTE)DEFAULT NULL, "IDENTIFY"VARCHAR2(255BYTE)DEFAULT NULL, "Leavereasonid" Number( One)DEFAULT NULL, "Leavetime"TIMESTAMP(0)DEFAULT NULL, "Mobilephone"VARCHAR2(255BYTE)DEFAULT NULL, "OFFICE"VARCHAR2(255BYTE)DEFAULT NULL, "ORGID"VARCHAR2(255BYTE)DEFAULT NULL, "OrgName"VARCHAR2(255BYTE)DEFAULT NULL, "PASSWORD"VARCHAR2(255BYTE)DEFAULT NULL, "PositionID" Number( One)DEFAULT NULL, "Reachtime"TIMESTAMP(0)DEFAULT NULL, "Sortsno" Number( One)DEFAULT NULL, "userimg"VARCHAR2(255BYTE)DEFAULT NULL, "USERNAME"VARCHAR2(255BYTE)DEFAULT NULL, "Workstatusid" Number( One)DEFAULT NULL, "STATUS" Number( One)DEFAULT NULL, "Certypeid" Number( One)DEFAULT NULL, "Minzuid" Number( One)DEFAULT NULL, "PERSONID"VARCHAR2(255BYTE)DEFAULT NULL,  PRIMARY KEY("USERID"))

To execute the MySQL Data Export command:

mysql-h172. 166.230. 229 " Use gguser; select* from Gg_user; " >/tmp/test.sql

Write Sqlldr Import Control file

Load Datacharacterset'UTF8'infile'/tmp/test.sql'Replace into table PALACE. Gg_userfields terminated by X' the'optionally enclosed by'"'(userid nullif (userid='NULL'), Ispart Nullif (ispart='NULL'), Actualpositionid Nullif (actualpositionid='NULL'), Beginworktime timestamp"YYYY-MM-DD"Nullif (beginworktime='NULL'), BIRTHDAY timestamp"YYYY-MM-DD"Nullif (birthday='NULL'), Cardno Nullif (cardno='NULL'), EMAIL Nullif (email='NULL'), Genderid Nullif (genderid='NULL'), Healthid Nullif (healthid='NULL'), HOME Nullif (home='NULL'), IDENTIFY Nullif (identify='NULL'), Leavereasonid Nullif (leavereasonid='NULL'), Leavetime timestamp"YYYY-MM-DD"Nullif (leavetime='NULL'), Mobilephone Nullif (mobilephone='NULL'), OFFICE Nullif (office='NULL'), ORGID Nullif (orgid='NULL'), OrgName Nullif (orgname='NULL'), PASSWORD Nullif (password='NULL'), PositionID Nullif (positionid='NULL'), Reachtime timestamp"YYYY-MM-DD"Nullif (reachtime='NULL'), Sortsno Nullif (sortsno='NULL'), Userimg Nullif (userimg='NULL'), USERNAME Nullif (username='NULL'), Workstatusid Nullif (workstatusid='NULL'), STATUS Nullif (status='NULL'), Certypeid Nullif (certypeid='NULL'), Minzuid Nullif (minzuid='NULL'), PERSONID Nullif (personid='NULL'))

Perform a SQLLDR import operation

./sqlldr userid='username/pwd' control='/tmp/ctl.ctl' log= ' /tmp/ctl.log '

MySQL Import data into Oracle