| 澶辨晥閾炬帴澶勭悊 |
|
oracle鏁版嵁搴撳鍏ュ鍑鴻鏄?PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1PrrMoQ-qppN2u_YIuB7Qzw
鎻愬彇鐮侊細a8vg
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
浜斻€佹暟鎹簱瀵煎叆瀵煎嚭銆?/div>
錛堣繖涓唴瀹規(guī)瘮杈冨銆傝繖閲屾湁涓瘮杈冭灝界殑鏂囩珷銆傚師鏂囬摼鎺ュ湪涓嬫柟銆傝嚜宸變篃鎽樺綍浜嗕竴涓嬶紝鏂逛究浠ュ悗鏌ョ湅銆傦級
oracle11g鏁版嵁搴撳鍏ュ鍑猴細
鈶?浼犵粺鏂瑰紡——exp(瀵煎嚭)鍜?imp)瀵煎叆錛?/div>
鈶?鏁版嵁娉墊柟寮?mdash;—expdp瀵煎嚭鍜岋紙impdp錛夊鍏?
鈶?絎笁鏂瑰伐鍏?mdash;—PL/sql Develpoer;
涓€銆佷粈涔堟槸鏁版嵁搴撳鍏ュ鍑猴紵
oracle11g鏁版嵁搴撶殑瀵煎叆/瀵煎嚭錛屽氨鏄垜浠€氬父鎵€璇寸殑oracle鏁版嵁鐨勮繕鍘?澶囦喚銆?/div>
鏁版嵁搴撳鍏?鎶?dmp 鏍煎紡鏂囦歡浠庢湰鍦板鍏ュ埌鏁版嵁搴撴湇鍔″櫒涓?鏈湴oracle嫻嬭瘯鏁版嵁搴撲腑);
鏁版嵁搴撳鍑?鎶婃暟鎹簱鏈嶅姟鍣ㄤ腑鐨勬暟鎹?鏈湴oracle嫻嬭瘯鏁版嵁搴撲腑鐨勬暟鎹?,瀵煎嚭鍒版湰鍦扮敓鎴?dmp鏍煎紡鏂囦歡銆?/div>
.dmp 鏍煎紡鏂囦歡錛氬氨鏄痮racle鏁版嵁鐨勬枃浠舵牸寮?姣斿瑙嗛鏄?mp4 鏍煎紡,闊充箰鏄?mp3 鏍煎紡);
浜屻€佷簩鑰呬紭緙虹偣鎻忚堪錛?/div>
1.exp/imp:
浼樼偣:浠ｇ爜涔﹀啓綆€鍗曟槗鎳?浠庢湰鍦板嵆鍙洿鎺ュ鍏ワ紝涓嶇敤鍦ㄦ湇鍔″櫒涓搷浣滐紝闄嶄綆闅懼害錛屽噺灝戞湇鍔″櫒涓婄殑鎿嶄綔涔熷氨 淇濊瘉浜嗘湇鍔″櫒涓婃暟鎹枃浠剁殑瀹夊叏鎬с€?/div>
緙虹偣錛氳繖縐嶅鍏ュ鍑虹殑閫熷害鐩稿杈冩參錛屽悎閫傛暟鎹簱鏁版嵁杈冨皯鐨勬椂鍊欍€傚鏋滄枃浠惰秴榪囧嚑涓狦錛屽ぇ浼楁€ц兘鐨勭數 鑴戯紝鑷沖皯闇€瑕?~5涓皬鏃跺乏鍙熾€?/div>
2.expdp/impdp:
浼樼偣:瀵煎叆瀵煎嚭閫熷害鐩稿杈冨揩,鍑犱釜G鐨勬暟鎹枃浠朵竴鑸湪1~2灝忔椂宸﹀彸銆?/div>
緙虹偣:浠ｇ爜鐩稿涓嶆槗鐞嗚В,瑕佹兂瀹炵幇瀵煎叆瀵煎嚭鐨勬搷浣滐紝蹇呴』鍦ㄦ湇鍔″櫒涓婂垱寤洪€昏緫鐩綍(涓嶆槸鐪熸鐨勭洰褰?銆傛垜浠?nbsp; 閮界煡閬撴暟鎹簱鏈嶅姟鍣ㄧ殑閲嶈鎬э紝鎵€浠ュ湪涓婇潰鐨勬搷浣滃繀欏繪厧閲嶃€傛墍浠ヨ繖縐嶆柟寮忎竴鑸敱涓撲笟鐨勭▼搴忎漢鍛樻潵瀹?nbsp; 鎴?涓嶄竴瀹氭槸DBA(鏁版嵁搴撶鐞嗗憳)鏉ュ共,涓皬鍏徃鍙兘娌℃湁DBA)銆?/div>
3.PL/sql Develpoer:
浼樼偣錛氬皝瑁呬簡瀵煎叆瀵煎嚭鍛戒護錛屾棤闇€姣忔閮芥墜鍔ㄨ緭鍏ュ懡浠ゃ€傛柟渚垮揩鎹鳳紝鎻愰珮鏁堢巼銆?/div>
緙虹偣錛氶暱鏃墮棿搴旂敤浼氬鍏朵駭鐢熶緷璧栵紝闄嶄綆瀵逛唬鐮佹墽琛屽師鐞嗙殑鐞嗚В銆?/div>
涓夈€佺壒鍒己璋冿細
鐩爣鏁版嵁搴?鏁版嵁鍗沖皢瀵煎叆鐨勬暟鎹簱(涓€鑸槸欏圭洰涓婃寮忔暟鎹簱);
婧愭暟鎹簱:鏁版嵁瀵煎嚭鐨勬暟鎹簱(涓€鑸槸欏圭洰涓婄殑嫻嬭瘯鏁版嵁搴?;
1.鐩爣鏁版嵁搴撹涓庢簮鏁版嵁搴撴湁鐫€鍚嶇О鐩稿悓鐨勮〃絀洪棿銆?/div>
2.鐩爣鏁版嵁鍦ㄨ繘琛屽鍏ユ椂錛岀敤鎴峰悕灝介噺鐩稿悓(榪欐牱淇濊瘉鐢ㄦ埛鐨勬潈闄愮駭鍒浉鍚?銆?/div>
3.鐩爣鏁版嵁搴撴瘡嬈″湪榪涜鏁版嵁瀵煎叆鍓嶏紝搴斿仛濂芥暟鎹浠斤紝浠ラ槻鏁版嵁涓㈠け銆?/div>
4.浣跨敤鏁版嵁娉墊椂,涓€瀹氳鐜板湪鏈嶅姟鍣ㄧ寤虹珛鍙敤鐨勯€昏緫鐩綍錛屽茍媯€鏌ユ槸鍚﹀彲鐢ㄣ€?/div>
5.寮勬竻鏄鍏ュ鍑哄埌鐩稿悓鐗堟湰榪樻槸涓嶅悓鐗堟湰(oracle10g鐗堟湰涓巓racle11g鐗堟湰)銆?/div>
6.鐩爣鏁版嵁瀵煎叆鍓?寮勬竻妤氭槸鏁版嵁瑕嗙洊(鏇挎崲),榪樻槸浠呮彃鍏ユ柊鏁版嵁鎴栨浛鎹㈤儴鍒嗘暟鎹〃銆?/div>
7.紜畾鐩爣鏁版嵁搴撶鐩樼┖闂存槸鍚﹁凍澶熷綰蟲柊鏁版嵁錛屾槸鍚﹂渶瑕佹墿鍏呰〃絀洪棿銆?/div>
8.瀵煎叆瀵煎嚭鏃舵敞鎰忓瓧絎﹂泦鏄惁鐩稿悓錛屼竴鑸琌racle鏁版嵁搴撶殑瀛楃闆嗗彧鏈変竴涓紝騫朵笖鍥哄畾錛屼竴鑸笉鏀瑰彉銆?/div>
9.瀵煎嚭鏍煎紡浠嬬粛:
銆€ Dmp鏍煎紡錛?dmp鏄簩榪涘埗鏂囦歡錛屽彲璺ㄥ鉤鍙幫紝榪樿兘鍖呭惈鏉冮檺錛屾晥鐜囧ソ錛?/div>
銆€ Sql鏍煎紡錛?sql鏍煎紡鐨勬枃浠訛紝鍙敤鏂囨湰緙栬緫鍣ㄦ煡鐪嬶紝閫氱敤鎬ф瘮杈冨ソ錛屾晥鐜囦笉濡傜涓€縐嶏紝
閫傚悎灝忔暟鎹噺瀵煎叆瀵煎嚭銆傚挨鍏舵敞鎰忕殑鏄〃涓笉鑳芥湁澶у瓧孌?錛坆lob,clob,long錛夛紝濡傛灉鏈夛紝浼氭姤閿欙紱
銆€ Pde鏍煎紡錛?pde鏍煎紡鐨勬枃浠訛紝.pde涓篜L/SQL Developer鑷湁鐨勬枃浠舵牸寮忥紝鍙兘鐢≒L/SQL Developer宸ュ叿
瀵煎叆瀵煎嚭錛屼笉鑳界敤鏂囨湰緙栬緫鍣ㄦ煡鐪嬶紱
10.紜畾鎿嶄綔鑰呯殑璐﹀彿鏉冮檺銆?span style="white-space:pre">
鍥涖€佷簩鑰呯殑瀵煎叆瀵煎嚭鏂規(guī)硶錛?/div>
1銆佷紶緇熸柟娉曪細
閫氱敤鍛戒護:exp(imp) username/password@SERVICENAME:1521 file=“e:\temp.dmp” full = y;
鏁版嵁搴撳鍑轟婦渚?
exp xinxiaoyong/123456@127.0.0.1:1521 file=“e:\temp.dmp” full = y;
exp:瀵煎嚭鍛戒護錛屽鍑烘椂蹇呭啓銆?/div>
imp:瀵煎叆鍛戒護錛屽鍏ユ椂蹇呭啓,姣忔鎿嶄綔錛屼簩鑰呭彧鑳介€夋嫨涓€涓墽琛屻€?/div>
username:瀵煎嚭鏁版嵁鐨勭敤鎴峰悕錛屽繀鍐?
password:瀵煎嚭鏁版嵁鐨勫瘑鐮侊紝蹇呭啓;
@:鍦板潃絎﹀彿錛屽繀鍐?
SERVICENAME:Oracle鐨勬湇鍔″悕錛屽繀鍐?
1521:绔彛鍙鳳紝1521鏄粯璁ょ殑鍙互涓嶅啓,闈為粯璁よ鍐?
file=“e:\temp.dmp” : 鏂囦歡瀛樻斁璺緞鍦板潃錛屽繀鍐?
full=y :琛ㄧず鍏ㄥ簱瀵煎嚭銆傚彲浠ヤ笉鍐欙紝鍒欓粯璁や負no,鍒欏彧瀵煎嚭鐢ㄦ埛涓嬬殑瀵硅薄;
鏂規(guī)硶緇嗗垎錛?/div>
1.瀹屽叏瀵煎叆瀵煎嚭錛?/div>
exp(imp) username/password@SERVICENAME:1521 file=“e:\temp.dmp” full = y;
2.閮ㄥ垎鐢ㄦ埛琛╰able瀵煎叆瀵煎嚭錛?/div>
exp(imp) username/password@SERVICENAME:1521 file=“e:\temp.dmp” tabels= (table1,table2,table3,…);
3.琛ㄧ┖闂磘ablespaces瀵煎叆瀵煎嚭錛?/div>
//涓€涓暟鎹簱瀹炰緥鍙互鏈塏涓〃絀洪棿(tablespace)錛屼竴涓〃絀洪棿涓嬪彲浠ユ湁N寮犺〃(table)銆?/div>
exp(imp) username/password@SERVICENAME:1521 file=“e:\temp.dmp” tablespaces= (tablespace1,tablespace2,tablespace3,…);
4.鐢ㄦ埛鍚島sername瀵硅薄瀵煎叆瀵煎嚭錛?/div>
exp(imp) username/password@SERVICENAME:1521 file=“e:\temp.dmp” owner(username1,username2,username3);
2銆佹暟鎹車鏂規(guī)硶錛?/div>
鍒涘緩directory:
expdp(impdp) username/password@SERVICENAME:1521 schemas=username dumpfile=file1.dmp logfile=file1.log directory=testdata1 remap_schema=test:test;
鏁版嵁搴撳鍑轟婦渚?
expdp xinxiaoyong/123456@127.0.0.1:1521 schemas=xinxiaoyong dumpfile=test.dmp
logfile=test.log directory=testdata1;
exp:瀵煎嚭鍛戒護錛屽鍑烘椂蹇呭啓銆?/div>
imp:瀵煎叆鍛戒護錛屽鍏ユ椂蹇呭啓,姣忔鎿嶄綔錛屼簩鑰呭彧鑳介€夋嫨涓€涓墽琛屻€?br />
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
