oracle的expdp导出模式能一次把多个表空间导出来吗 expdp 导出方案后 impdp导入新数据库需要建立表空间...
expdp \u5bfc\u51fa\u65b9\u6848\u548c\u8868\u7a7a\u95f4\u7684\u533a\u522b\u5bfc\u51fa\u8868\u7a7a\u95f4
C:\>expdp system/orcl@orcl directory=dump_dir dumpfile=tablespace.dmp logfile=ta
blespace.log tablespaces=tbs01,tbs02
Export: Release 10.2.0.1.0 - Production on \u661f\u671f\u65e5, 04 1\u6708, 2009 11:20:05
Copyright (c) 2003, 2005, Oracle. All rights reserved.
\u8fde\u63a5\u5230: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
\u542f\u52a8 "SYSTEM"."SYS_EXPORT_TABLESPACE_01": system/********@orcl directory=dump_d
ir dumpfile=tablespace.dmp logfile=tablespace.log tablespaces=tbs01,tbs02
\u6b63\u5728\u4f7f\u7528 BLOCKS \u65b9\u6cd5\u8fdb\u884c\u4f30\u8ba1...
\u5904\u7406\u5bf9\u8c61\u7c7b\u578b TABLE_EXPORT/TABLE/TABLE_DATA
\u4f7f\u7528 BLOCKS \u65b9\u6cd5\u7684\u603b\u4f30\u8ba1: 128 KB
\u5904\u7406\u5bf9\u8c61\u7c7b\u578b TABLE_EXPORT/TABLE/TABLE
. . \u5bfc\u51fa\u4e86 "SCOTT"."TAB01" 4.937 KB 2 \u884c
. . \u5bfc\u51fa\u4e86 "SCOTT"."TAB02" 4.937 KB 2 \u884c
\u5df2\u6210\u529f\u52a0\u8f7d/\u5378\u8f7d\u4e86\u4e3b\u8868 "SYSTEM"."SYS_EXPORT_TABLESPACE_01"
******************************************************************************
SYSTEM.SYS_EXPORT_TABLESPACE_01 \u7684\u8f6c\u50a8\u6587\u4ef6\u96c6\u4e3a:
D:\DUMP\TABLESPACE.DMP
\u4f5c\u4e1a "SYSTEM"."SYS_EXPORT_TABLESPACE_01" \u5df2\u4e8e 11:20:27 \u6210\u529f\u5b8c\u6210
\u6ce8\u610f\uff1a\u5bfc\u51fa\u8868\u7a7a\u95f4\u8981\u6c42\u7528\u6237\u5fc5\u987b\u5177\u6709DBA \u89d2\u8272\u6216EXP_FULL_DATABASE \u89d2\u8272\u3002
\u6211\u505a\u8fc7\u8fd9\u6837\u7684\u9879\u76ee\uff0c\u6211\u8bb0\u5f97expdp\u5bfc\u51fa\u7684\u6570\u636e\u662f\u653e\u5728\u670d\u52a1\u5668\u7aef\u7684\uff0c\u4f60\u8981\u662f\u7528impdp\u547d\u4ee4\u5bfc\u5165\u6570\u636e\u5e93\u7684\u65f6\u5019\uff0c\u8868\u540d\u548cschema\u8981\u4e00\u6837\u7684\u3002
可以的expdp username/password directory=dmp_dir dumpfile=expdp_dmp.dmp tablespaces=tbs_1,tbs_2 logfile=expdp_dmp.log
按用户导出吧。
绛旓細expdp鏈夊帇缂╂ā寮忋佷笉鍘嬬缉妯″紡涓ょ锛氫笉鍘嬬缉妯″紡灏辨槸鏁版嵁鏈夊灏戯紝鏂囦欢灏辨湁澶氬ぇ锛岄熷害蹇紝杩欐槸浠ョ┖闂存崲鏃堕棿銆傚帇缂╂ā寮瀵煎嚭鏂囦欢浼氭瘮涓嶅帇缂╂ā寮忓皬1/3锝2/3锛屼絾鏄鍑洪熷害浼氭參浜涳紝杩欐槸浠ユ椂闂存崲绌洪棿銆
绛旓細3銆佹墽琛瀵煎嚭 expdp zftang/zftang@fgisdb schemas=zftang directory=dir_dp dumpfile =expdp_test1.dmp logfile=expdp_test1.log;杩炴帴鍒: Oracle Database 10g Enterprise Edition Release 10.2.0.1 With the Partitioning, OLAP and Data Mining options 鍚姩 "ZFTANG"."SYS_EXPORT_SCHEMA_01": ...
绛旓細1 鍒涘缓TNS鏂囦欢锛2 鍒涘缓DBLINK 3 expdp鍊掑簱鏃舵寚瀹歯etwork_link鍙傛暟
绛旓細鍙互灏濊瘯浣跨敤UltraEdit涔嬬被鐨勫瓧绗﹀垎鏋愯蒋浠跺dmp鏂囦欢杩涜鏁版嵁鍒嗘瀽锛屽鏋滆兘鍒嗘瀽鍑哄疄闄呭唴瀹癸紝鍙互鎶㈡晳閮ㄥ垎鏁版嵁锛屼絾瀹屾暣鐨勬暟鎹及璁℃槸鎶㈡晳涓嶄簡浜嗭紝闄ら潪浣犲湪鍏跺畠绗笁鏂圭殑缃戠洏鎴栬呯Щ鍔ㄧ‖鐩樻湁澶囦唤銆
绛旓細Oracle 渚濅緷g鏁版嵁瀵煎叆鍒颁緷0g 涓銆佸湪渚濅緷g鏈嶅姟鍣ㄤ笂锛屼娇鐢expdp鍛戒护澶囦唤鏁版嵁 渚濅緷g 瀵煎嚭璇彞锛EXPDP USERID='facial/facial@orcl as sysdba' schemas=facialdirectory=DATA_PUMP_DIR dumpfile=test.dmp logfile=test.log version=渚0.璐.0.渚.0 浜屻佸湪渚0g鏈嶅姟鍣ㄤ笂锛屼娇鐢╥mpdp鍛戒护鎭㈠鏁版嵁 鍑嗗宸ヤ綔...
绛旓細Oracle11.2.0.3 锛 Red Hat Linux 5.8 灏唗able鍏ㄩ儴鍐欎笅鏉ュ綋鐒舵槸鍙互锛 鍒嗘垚鍑犵粍瀵煎嚭涔熷彲浠ャ 涓嶈繃鏌ヨ浜嗕竴浜涙柟娉曪紝 鏈変粙缁峞xclude 鍚庨潰鎺ュ瓙鏌ヨ鐨勫彲浠ヤ笉鐢ㄥ啓 闈炲父闀挎墽琛屽懡浠ゆ垨浣跨敤鍙傛暟鏂囦欢鐨勶紝 灏濊瘯浜嗕竴涓嬶紝 鎬绘槸鎵ц涓浼氬埌瀵煎嚭view 鐨勬椂鍊欐姤涓ラ噸閿欒锛 灏遍鍑轰簡锛
绛旓細涓昏鏄洜涓烘墍鎸囧畾鐨刣ump_dir鎵鍦ㄧ殑鐩綍涓嶅瓨鍦ㄦ垨鐩綍鍚嶇О涓嶅锛屾病鏈夐偅涓枃浠跺す锛屽氨鏃犳硶鍦ㄦ枃浠跺す閲屽垱寤簂og鏂囦欢锛屽氨鎻愮ず杩欎釜閿欒浜嗭紝瑙ｅ喅鏂规硶鏄紝鐢╬lsql杩炴帴涓婏紝鎵惧埌directory涓嬬殑dump_dir 杩涜缂栬緫锛屾煡鐪嬬洰褰曟槸鍚︽纭紝涓嶆纭殑璇濊繘琛屼慨鏀广
绛旓細杩勪粖涓烘 瀵煎嚭/瀵煎叆宸ュ叿闆嗕粛鏄法澶氫釜骞冲彴杞Щ鏁版嵁鎵闇鍔冲姩寮哄害鏈灏忕殑棣栭夊疄鐢ㄥ伐鍏 灏界浜轰滑甯稿父鎶辨ㄥ畠閫熷害澶參 瀵煎叆鍙槸灏嗘瘡鏉¤褰曚粠瀵煎嚭杞偍鏂囦欢涓鍑烘潵 鐒跺悗浣跨敤甯歌鐨 INSERT INTO 鍛戒护灏嗗叾鎻掑叆鍒扮洰鏍囪〃涓 鍥犳瀵煎叆鍙兘鏄釜寰堟參鐨勮繃绋 杩欎竴鐐瑰苟涓嶈浜烘劅鍒板悆鎯 杩涘叆Oracle Data Pump Oracle Database g 涓殑瀵...
绛旓細涓嶆槸娌℃湁浜嗭紝鏄鍦瀵煎嚭锛屽洜涓烘枃浠跺緢澶э紝杩欓噷鐪嬫槸2.041 GB锛屾墍浠ュ鍑洪渶瑕佹椂闂达紝瀵煎嚭瀹屾垚鍚庝細鏈夊鍑烘垚鍔熷瓧鏍凤紝鎴栬呭鍑烘垚鍔熸垨鏈夐棶棰橈紝鎴栬呭鍑轰笉鎴愬姛锛屼綘鐜板湪杩欎釜灏辨槸杩樻病瀵煎畬锛屼綘澶潃鎬ヤ簡銆傚鏋滃鍑烘垚鍔燂紝閭ｄ箞瀵煎叆鏄病鏈夐棶棰樼殑锛屽綋鐒跺彲鑳介渶瑕佸缓绔嬬敤鎴蜂粈涔堢殑锛屾垜閬囧埌杩囧鍏ユ椂鎶ユ病鏈夌敤鎴凤紝娌℃湁琛ㄧ┖闂磋繖绫...
绛旓細鏃犳硶鏇存柊锛屼笉鑳絠nsert锛寀pdate鏄繖涓剰鎬濆惂銆傚鏋滄槸鐢熶骇绯荤粺锛岄偅涔堜笉濂芥剰鎬濓紝杩欐槸鍦ㄦ壘浜嬶紝浜ゆ槗琛ㄧ瓑绛夐兘鏄渶瑕佹椂鏃舵洿鏂扮殑锛屼笉鍙兘鍥犱负浣犺瀵兼暟鑰岀粓姝紝濡傛灉缁堟浜嗗氨涓嶆槸瀵兼暟鐨勯棶棰樹簡锛岃屾槸椤圭洰杩樿兘涓嶈兘鍋氱殑闂銆傚鏋滄槸鐢熶骇绯荤粺锛屼竴鑸細閫夋嫨鐢ㄦ埛灏戠殑鏃跺欏鏁帮紝姣斿鍗婂锛屾垨鑰呭噷鏅2-3鐐瑰乏鍙筹紙瀹氭椂鎵ц锛屽ご...
