Shulou(Shulou.com)05/31 Report--

Editor to share with you the mysql database and oracle database into each other into the backup example analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

Import data exported from the Oracle database into the MySql database

1. Import into the MySql database using the default closing symbol:

LOAD DATA LOCAL INFILE'dlugo oracle.txt' IGNORE INTO TABLE alarmLog

At this point, the Terminator of Fields defaults to the'/ t 'tab, not the / t string.

two。 When the set Fields Terminator is imported into the MySql database:

LOAD DATA LOCAL INFILE'dlugo oraclea.txt 'IGNORE INTO TABLE alarmLog FIELDS TERMINATED BY' ~'

The data files oracle.txt and oraclea.txt used in the above two cases are exported through the ociuldr.exe program.

Import the data exported from MySql into the oracle database

1. Import data from the MySql database into a file by setting the Fields Terminator

Select * from alarmLog into outfile'dVOGUGUM mysql.txt' FIELDS TERMINATED BY'~'

Import the d:/mysql.txt data file into the oracle database through sqlldr. Pay attention to the writing of the control file, the following is the corresponding control file of the test program.

OPTIONS (BINDSIZE=8388608,READSIZE=8388608,ERRORS=-1,ROWS=50000) LOAD DATAINFILE'dSTR 'INTO TABLE instantdataFIELDS TERMINATED BY' ~ 'TRAILING NULLCOLS (FIELDID CHAR (20), CreateTIME date' yyyy-mm-dd hh34:mi:ss', AckTIME date 'yyyy-mm-dd hh34:mi:ss', TYPE CHAR (40), QUALITY CHAR (40), VALUE CHAR (40), AVG CHAR (40), MAX CHAR (40), MIN CHAR (40) SUM CHAR (40)) these are all the contents of the article "sample Analysis of Import and backup between mysql Database and oracle Database" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.