{"data":{"question_details":{"data":{"answers":[{"qid":"6735988669804462348","aid":"6810696482862137613","uid":"347080542389758","uname":"用戶3494949202203","avatar_url":"https://p9-passport.byteacctimg.com/img/mosaic-legacy/3795/3047680722~300x300.image","auth_info":"","content":"\u003cp\u003e您好，很高興為您解答。\u003c/p\u003e\u003cp\u003e一、將表中數據導入文本文件保存\u003c/p\u003e\u003cp\u003e我是在WIN下的命令行模式做的\u003c/p\u003e\u003cp\u003eMysql>select * from my_mysql_table into outfile 'c: /my_tmp.txt';\u003c/p\u003e\u003cp\u003e二、寫控制文件\u003c/p\u003e\u003cp\u003e用記事本開文檔寫完后改擴展名為.ctl，以下是具體內容\u003c/p\u003e\u003cp\u003eload data\u003c/p\u003e\u003cp\u003einfile 'c:/my_tmp.txt'\u003c/p\u003e\u003cp\u003einto table my_ora_table\u003c/p\u003e\u003cp\u003ereplace \u003c/p\u003e\u003cp\u003efields terminated by x'09'\u003c/p\u003e\u003cp\u003e(字段1，字段2，字段3，......字段N)\u003c/p\u003e\u003cp\u003e字段1~N是你要導入的MySql的表字段數據，不需要的字段可以不寫。\u003c/p\u003e\u003cp\u003e三、用Sqlldr導入文本\u003c/p\u003e\u003cp\u003ec:\\>sqlldr ora_usr\u003c/p\u003e\u003cp\u003e回車后輸入控制文件的路徑，密碼，接下來加載控制文件自動導入。導入完成后，會生成個.log文件，可以查看你導入是否成功，不成功按提示的錯誤查找原因。\u003c/p\u003e\u003cp\u003e注意的是：導入文本前，應在ORACLE數據庫中事先建好要寫入數據的表，并且要和所要導入的數據字段一致，如果不知MySql的表結構，可以在Mysql>show create table my_mysql_table；查看建表的SQL，將其轉換成Oracle中可執行的SQL. \u003c/p\u003e","abstract":"您好，很高興為您解答。一、將表中數據導入...","create_time":1585738845,"update_time":1673982905,"digg_info":{"digg_count":0,"own_digg":false,"digg_list":null},"comment_info":{"comment_count":0},"repost_info":{"repost_count":0},"audit_info":{"audit_status":-1,"audit_status_msg":"","audit_status_msg_desc":""},"pv":0,"vl":65,"content_with_entity":"","extra":{"group_decay_type":"9","modify_time":"1673982905","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"65\",\"editor\":\"toutiao.search_content.script\",\"reason_code\":0}","reviewed_level":"11","ugc_shark_decision":"{\"Decision\": \"BLOCK\", \"DecisionDetail\": \"reject\", \"HitStatus\": \"{\\\"32473\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"reject\\\"}}\"}","wd_activity_from":"answer_get_bonus","wd_source":"question_click_write_answer","wdh_client_ip":"14.29.32.162"},"integral_order_list":null,"integral_count":0,"bury_info":{"bury_count":0,"own_bury":false},"sent_flower_status":0,"could_show_flower_text":false,"author_digg_count":159,"author_show_digg_status":true,"ban_comment":false,"relation_info":{"is_following":false},"user_status":{"is_cancelled":false,"is_banned":false},"feedback_user_not_acted_aid":true,"help_info":{"is_helpful_count":0,"own_is_helpful":false}}],"has_more":false,"question":{"qid":"6735988669804462348","title":"如何將MySql數據導入至Oracle中？","content":"","pictures":null,"answer_count":1,"pv":673,"embrave":{"embrave_type":0,"integral_count":0,"gold_count":0,"reward_time":0},"create_time":1568344577,"vl":65,"audit_info":{"audit_status":2,"audit_status_msg":"","audit_status_msg_desc":""},"new_answer_cnt":0,"question_belong_status":2,"user_info":{"uid":"","uname":"陳坐光","avatar_url":"https://sf3-cdn-tos.toutiaostatic.com/img/mosaic-legacy/8615/1682352524~300x300.image"},"extra":{"has_out_answer":"1","modify_time":"1674584834","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"65\",\"editor\":\"toutiao.search_content.script\",\"reason_code\":0}","wdh_client_ip":"127.0.0.1"},"img_q_integral":0,"feedback_user_not_answered":true,"feedback_user_not_acted":true},"rank1_could_show_flower_text":false,"contentType":"application/json; charset=utf-8","fontStyle":{"domains":["tosv.boe.byted.org"],"filename":"","base64":[],"fontKey":"","tosSuffix":""},"fontKey":"","fontStyleString":""},"errcode":0,"errmsg":"success"},"login_info":{"data":{"is_answered":1,"is_new":true,"uid":"","user_info":{"uid":"","uname":"","avatar_url":""}},"errcode":0,"errmsg":"success"}},"commonData":{"isSsrFrame":true,"ttLogId":"202302092112380101501341671EC018ED","location":{"hash":"","host":"so.toutiao.com","hostname":"so.toutiao.com","href":"https://so.toutiao.com/s/search_wenda_pc/list/?enter_from=search_result&qid=6735988669804462348&qname=如何將MySql數據導入至Oracle中？&search_id=202302092112350101501341671EC018D9&enter_answer_id=6810696482862137613&outer_show_aid=6810696482862137613&query=mysql怎么導入數據庫","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6735988669804462348&qname=如何將MySql數據導入至Oracle中？&search_id=202302092112350101501341671EC018D9&enter_answer_id=6810696482862137613&outer_show_aid=6810696482862137613&query=mysql怎么導入數據庫","username":"","password":""},"query":{"enter_from":"search_result","qid":"6735988669804462348","qname":"如何將MySql數據導入至Oracle中？","search_id":"202302092112350101501341671EC018D9","enter_answer_id":"6810696482862137613","outer_show_aid":"6810696482862137613","query":"mysql怎么導入數據庫"},"client":{"width":1920,"height":880,"pixelRatio":1,"userAgent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36","isPC":true,"platform":"windows"},"serverEnv":"production","abFields":{},"user":{"webId":"7167564658018354696"},"isRPC":false,"params":{},"env":{"isBOE":false,"isProd":true,"isPPE":false,"cluster":"default"},"routingInfos":{"tc":"search_wenda_pc","business_path":"/list","routing_path":"/"}}}