Shulou(Shulou.com)06/01 Report--

How to import mysql into oracle? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql import oracle method: first of all, the data in the table into the text file to save; then write the control file, and use notepad to open the document, after writing to change the extension to ".ctl"; then use sqlldr to import the text; finally load the control file to import automatically.

Import the mysql database into oracle:

The first method: use the data migration tool

The second method:

First, import the data in the table into a text file and save it. I did it in Mysql > select * from my_mysql_table into outfile'c: / my_tmp.txt' in the command line mode under win.

Second, write the control file with notepad and change the name to .ctl after writing. The following is the specific content of load datainfile 'c:/my_tmp.txt'into table my_ora_tablereplace fields terminated by xan09' (field 1, field 2, field 3. Field N) Field 1. Field N is the table field data of the Mysql you want to import, and you don't have to write the fields you don't need.

Third, use sqlldr to import the text c:\ > sqlldr ora_usr enter the path and password of the control file, and then load the control file to import automatically.

After the import is completed, a .log file will be generated, which can check whether your import is successful or not, and find the reason for the error if you are not successful.

Note that:

Before importing the text, you should build a table to write data in the oracle database, and it should be consistent with the data field to be imported. If you do not know the table structure of Mysql, you can view the SQL of the table in Mysql > show create table my_mysql_table; and convert it into executable SQL in oracle.

Thank you for reading! After reading the above, do you have a general understanding of the method of importing oracle into mysql? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are 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.