oracle用expdp导出过程中对数据库使用有没有影响 oracle数据泵 expdp能直接使用吗
\u5bf9\u6570\u636e\u5e93\u505aEXPDP\u548cIMPDP\u80fd\u63d0\u5347\u6027\u80fd\u5417EXP\uff0cEXPDP\u6570\u636e\u5bfc\u5165\u672c\u5730\u6027\u80fd\u6d4b\u8bd5
\u672c\u6587\u7f16\u5199\u80cc\u666f\uff1a
\u5927\u5bb6\u90fd\u77e5\u9053\uff0cOracle\u6570\u636e\u5e93\u6709\u4e24\u79cd\u6bd4\u8f83\u65b9\u4fbf\u7684\u5bfc\u51fa\u5bfc\u5165\u5de5\u5177\uff0c\u90a3\u5c31\u662fexp/imp\u548cexpdp/impdp\u3002\u719f\u6089\u6b64\u5de5\u5177\u7684\u4eba\u4e5f\u4f1a\u4e86\u89e3\u5230\uff0cexp
/imp\u7684\u4f7f\u7528 \uff08\u670d\u52a1\u5668\u7aef\u548c\u5ba2\u6237\u7aef\u90fd\u53ef\u4ee5\u6267\u884c\uff0c\u5e76\u4e14\u5907\u4efd\u6587\u4ef6\u53ef\u4ee5\u5728\u5ba2\u6237\u7aef\u4ea7\u751f\uff09\uff1bexpdp/impdp\u7684\u4f7f\u7528
\uff08\u670d\u52a1\u5668\u7aef\u548c\u5ba2\u6237\u7aef\u90fd\u53ef\u4ee5\u6267\u884c\uff0c\u5907\u4efd\u6587\u4ef6\u53ea\u80fd\u5b58\u5728\u670d\u52a1\u5668\u91cc\u9762\uff09\u3002
\u4f46\u9274\u4e8e\u5bfc\u51fa\u5bfc\u5165\u5de5\u5177\u7684\u7279\u70b9\uff0c\u6211\u4eec\u5c31\u60f3\u80fd\u5426\u901a\u8fc7expdp\u5c06\u8fdc\u7aef\u6570\u636e\u5e93\u6570\u636e\u5bfc\u5165\u5230\u672c\u5730\u5e93\u4e2d\u5462\uff1f\u5f53\u7136\u53ef\u4ee5\uff01\u4e0b\u9762\u6211\u4eec\u5c31\u4e00\u8d77\u6765\u505a\u4e00\u4e2a\u6d4b\u8bd5\u5427\u3002
\u6d4b\u8bd5\u8bf4\u660e\uff1a
\u76ee\u7684\uff1a\u5c06\u8fdc\u7aef\u6570\u636e\u5e93\u670d\u52a1\u5668(IP\u4e3a65)\u7684\u6570\u636e\u5bfc\u5165\u5230\u672c\u5730(IP\u4e3a67)dmp\u6587\u4ef6\u4e2d
\u5176\u4e2d\u7528\u5230\u670d\u52a1\u5668(65)\u4e00\u4e2a\u7528\u6237(user_exp)\u7684\u4e00\u5f20\u8868\u505a\u6d4b\u8bd5(t_exp)
Create tablespace tbs_exp datafile \u2018D:\tbs_exp.dbf\u2019 size 10240m autoextend off;
Create user user_exp identified by user_exp default tablespace tbs_exp;
Grant connect,resource,unlimited tablespace to user_exp;
Conn user_exp/user_exp
create table t_exp as
select * from user_tablespaces;
declare
begin
for i in 1 .. 10000000 loop
insert into t_exp
(tablespace_name, block_size, initial_extent,MIN_EXTENTS )
values
('tablespace_name',0,0,i);
end loop;
commit;
end;
/
1\uff0eEXP\u5de5\u5177\u6570\u636e\u5bfc\u5165\u672c\u5730\u6b65\u9aa4
\u76f4\u63a5\u901a\u8fc7\u4ee5\u4e0b\u4ee3\u7801\u5c06\u670d\u52a1\u5668\u6570\u636e\u5bfc\u5165\u5230\u672c\u5730\uff1a
exp user_exp/user_exp@orcl_65 file=d:\exp_01.dmp log=d:\exp_01.log tables=(t_exp)
2\uff0eEXPDP\u5de5\u5177\u6570\u636e\u5bfc\u5165\u672c\u5730\u6b65\u9aa4
\u7b2c\u4e00\u6b65\uff1a\u672c\u5730\u5efa\u7acb\u5bfc\u51fa\u7528\u6237
Create user db_exp identified by db_exp;
Grant connect,resource,create database link to db_exp;
\u7b2c\u4e8c\u6b65\uff1a\u672c\u5730\u521b\u5efadirectory,\u5e76\u6388\u6743\u5bfc\u51fa\u7528\u6237\u4f7f\u7528
\u5728\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u521b\u5efadirexp\u76ee\u5f55
create or replace directory DIR_EXP as 'D:\direxp';
grant read,write on directory DIR_EXP to db_exp;
\u7b2c\u4e09\u6b65\uff1a\uff0c\u5e76\u521b\u5efadb link \u94fe\u63a5
-- Create database link
create database link to_exp_65
connect to user_exp identified by user_exp
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.48.1.65)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)
)
)';
Select 1 from dual@to_exp_65;
\u7b2c\u56db\u6b65\uff1a\u5bfc\u51fa\u4ee3\u7801
expdp db_exp/db_exp@orcl_67 directory=DIR_EXP dumpfile=expdp_01.dmp logfile=expdp_01.log tables=(t_exp) network_link=to_exp_65
\u5176\u4ed6\u5907\u6ce8\uff1a
Db_exp \u672c\u5730\u7528\u6237\uff0c\u7528\u6765\u8fde\u63a5\u8fdc\u7aef\u6570\u636e\u5e93\u670d\u52a1\u5668
Dir_exp \u672c\u5730db_exp\u7528\u6237\u4e0b \u7684 directory \u7528\u6237\u672c\u5730\u6307\u5b9aexpdp\u5199\u5165\u76ee\u5f55\uff0c\u8fd9\u91cc\u662fD\u76d8direxp\u6587\u4ef6\u5939
To_exp_65 \u672c\u5730db_exp\u7528\u6237\u4e0b\u7684 db link \uff0c\u7528\u6765\u8fde\u63a5\u8fdc\u7aef\u6570\u636e\u5e93\u670d\u52a1\u5668
3\uff0eEXP\uff0cEXPDP\u5de5\u5177\u6570\u636e\u5bfc\u5165\u672c\u5730\u6027\u80fd\u5bf9\u6bd4
\u6027\u80fd\u6d4b\u8bd5\u7ed3\u679c\uff1a
Exp\u5bfc\u51fa\u8fc7\u7a0b\u5982\u4e0b\uff1a
C:\Documents and Settings\Administrator>prompt $P$G$T$G
C:\Documents and Settings\Administrator>16:10:55.37>
C:\Documents and Settings\Administrator>16:11:05.92>exp user_exp/user_exp@orcl_6
5 file=d:\exp_01.dmp log=d:\exp_01.log tables=(t_exp)
Export: Release 10.2.0.1.0 - Production on \u661f\u671f\u4e09 10\u6708 12 16:11:07 2011
Copyright (c) 1982, 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
\u5df2\u5bfc\u51fa ZHS16GBK \u5b57\u7b26\u96c6\u548c AL16UTF16 NCHAR \u5b57\u7b26\u96c6
\u670d\u52a1\u5668\u4f7f\u7528 AL32UTF8 \u5b57\u7b26\u96c6 (\u53ef\u80fd\u7684\u5b57\u7b26\u96c6\u8f6c\u6362)
\u5373\u5c06\u5bfc\u51fa\u6307\u5b9a\u7684\u8868\u901a\u8fc7\u5e38\u89c4\u8def\u5f84...
. . \u6b63\u5728\u5bfc\u51fa\u8868 T_EXP\u5bfc\u51fa\u4e86 10000007 \u884c
\u6210\u529f\u7ec8\u6b62\u5bfc\u51fa, \u6ca1\u6709\u51fa\u73b0\u8b66\u544a\u3002
C:\Documents and Settings\Administrator>16:17:51.04>
\u7528\u65f6\uff1a6\u5206\u949f46\u79d2
1\u3001exp\u548cimp\u662f\u5ba2\u6237\u7aef\u5de5\u5177\u7a0b\u5e8f\uff0c\u5b83\u4eec\u65e2\u53ef\u4ee5\u5728\u5ba2\u6237\u7aef\u4f7f\u7528\uff0c\u4e5f\u53ef\u4ee5\u5728\u670d\u52a1\u7aef\u4f7f\u7528\u3002
2\u3001expdp\u548cimpdp\u662f\u670d\u52a1\u7aef\u7684\u5de5\u5177\u7a0b\u5e8f\uff0c\u4ed6\u4eec\u53ea\u80fd\u5728oracle\u670d\u52a1\u7aef\u4f7f\u7528\uff0c\u4e0d\u80fd\u5728\u5ba2\u6237\u7aef\u4f7f\u7528\u3002
3\u3001imp\u53ea\u9002\u7528\u4e8eexp\u5bfc\u51fa\u7684\u6587\u4ef6\uff0c\u4e0d\u9002\u7528\u4e8eexpdp\u5bfc\u51fa\u6587\u4ef6\uff1bimpdp\u53ea\u9002\u7528\u4e8eexpdp\u5bfc\u51fa\u7684\u6587\u4ef6\uff0c\u800c\u4e0d\u9002\u7528\u4e8eexp\u5bfc\u51fa\u6587\u4ef6\u3002
4\u3001\u5bf9\u4e8e10g\u4ee5\u4e0a\u7684\u670d\u52a1\u5668\uff0c\u4f7f\u7528exp\u901a\u5e38\u4e0d\u80fd\u5bfc\u51fa0\u884c\u6570\u636e\u7684\u7a7a\u8868\uff0c\u800c\u6b64\u65f6\u5fc5\u987b\u4f7f\u7528expdp\u5bfc\u51fa\u3002
绛旓細1锛岀洿鎺浣跨敤expdp锛宨mpdp杩涜瀵煎嚭瀵煎叆锛屽鏋滀笉鎶ラ敊锛屽彲浠ュ鍏ワ紝閭ｅ氨琛屻2锛屼笂杩版柟娉曚笉鍙互锛岄偅涔堜綘鍙互浣跨敤绗簩绉嶆柟娉曪紝鍗expdp瀵煎嚭鐨勬椂鍊欙紝娉ㄦ剰鍔犱笂鐗堟湰鐨勮浆鎹紝涔熷氨鏄妸瀵煎嚭鐨勭増鏈浆鍙樹负瑕佸鍏ョ殑鐗堟湰锛岀劧鍚庣洿鎺mpdp瀵煎叆鍒板悗闈㈣繖涓増鏈腑灏卞彲浠ャ備綘璇寸殑杩欑鎯呭喌锛屾垜瀵艰繃濂藉娆★紝鏈変簺鏃跺欐槸绗竴绉嶆柟娉...
绛旓細impdb鏄鍏ワ紝瀵煎嚭鏄痚xpdb鍛戒护锛屽鍑哄垎浠ヤ笅鍑犵銆1)鎸夌敤鎴峰 expdp scott/tiger@orcl schemas=scott dumpfile=expdp.dmp DIRECTORY=dpdata logfile=expdlog.log;2)骞惰杩涚▼parallel expdp scott/tiger@orcl directory=dpdata dumpfile=scott3.dmp parallel=40 job_name=scott3 logfile=expdlog.log 3)鎸...
绛旓細expdp鏄湪鏈嶅姟鍣ㄤ笂鎿嶄綔鐨勶紝寤虹殑杩欎釜鐩綍涔熸槸鏈嶅姟鍣ㄤ笂鐨勶紱鑰屼笖杩欎釜鐩綍闇瑕侀鍏堝湪鏈嶅姟鍣ㄤ笂寤哄ソ锛屾澶勬槸鍦Oracle涓缓绔嬩竴涓昏緫鐩綍锛屾寚鍚戞湇鍔″櫒涓婄殑鐗╃悊鐩綍銆俥xp鏄湪瀹㈡埛绔搷浣 杩欎袱涓伐鍏锋槸涓嶄竴鏍风殑銆
绛旓細瀵煎嚭澶囦唤鏈夊緢澶氱锛屾瘮濡俿ql鏍煎紡鍜宒mp鏍煎紡銆備綘鍙互鐢ㄥ懡浠xp robin/passwd@orcl(鏁版嵁搴撳疄渚嬪悕锛屼綘瀹夎鐨勬椂鍊欏懡浠ょ殑锛岄粯璁ゆ槸orcl) file='杩欎釜鏄綘瑕佸鍑虹殑瀛樻斁璺緞鏂囦欢浠.dmp' tables=(浣犺瀵煎嚭鐨勮〃鍚) /鎴栬呯洿鎺ョ敤full=y鏄鍑烘墍鏈夌殑
绛旓細澶撮儴楠岃瘉澶辫触鏄敱浜庣増鏈彿涓嶅悓鎵鑷达紝缁忚瘯楠屽彲浠ラ氳繃濡備笅鏂规硶杩涜淇敼锛氱敤notepad++宸ュ叿鎵撳紑dmp鏂囦欢锛屽彲浠ョ湅鍒板ご閮ㄤ俊鎭 锛嶏紞TEXPORT:V11.01.00锛屽嵆涓烘簮鏁版嵁搴撶殑鐗堟湰鍙凤紝灏嗗叾淇敼涓虹洰鐨勬暟鎹簱鐨勭増鏈彿锛屽鏈満鐨勭増鏈彿涓10.02.01锛屽啀娆¤繘琛屽鍏ユ搷浣滃皾璇曘傚鍏ヤ笉鎴愬姛涔熸湁鍙兘鏄洜涓烘暟鎹簱鐢ㄦ埛涓嶅閫犳垚鐨勩
绛旓細浣犳湁澶ч噺鐨勭┖BLOCKS鎵鑷达紝鏁版嵁搴撴棤鏁版嵁銆expdp鏈夊帇缂╂ā寮忋佷笉鍘嬬缉妯″紡涓ょ锛氫笉鍘嬬缉妯″紡灏辨槸鏁版嵁鏈夊灏戯紝鏂囦欢灏辨湁澶氬ぇ锛岄熷害蹇紝杩欐槸浠ョ┖闂存崲鏃堕棿銆傚帇缂╂ā寮瀵煎嚭鏂囦欢浼氭瘮涓嶅帇缂╂ā寮忓皬1/3锝2/3锛屼絾鏄鍑洪熷害浼氭參浜涳紝杩欐槸浠ユ椂闂存崲绌洪棿銆
绛旓細濡傛灉瀹炲湪涓嶈锛岄偅涔堟湁涓涓姙娉曪紙鍦ㄤ笉鏂紑浼氳瘽鐨勬儏鍐典笅鐨勩備笉杩囷紝锛侊紒锛侀儜閲嶆彁閱掞細涓汉鎰熻鏈濂戒笉瑕佺敤锛岀湡鐨勫嚭浜嬩簡锛岄偅灏遍夯鐑﹀ぇ浜嗭紝瀵逛簬dba鏉ヨ鈥滅ǔ瀹氬帇鍊掍竴鍒団濆晩銆傦級浣犳妸杩欎釜杩欎釜schema涓嬬殑琛ㄧ┖闂存敼涓哄彧璇伙紝杩欐牱涓嶈兘淇敼杩欎釜琛ㄧ┖闂翠笅鐨勬墍鏈夎〃浜嗭紝涓嶈繃鍏朵粬schema鍦ㄨ繖浜涜〃绌洪棿涓嬬殑琛紝涔熶笉鑳戒慨鏀逛簡锛...
绛旓細涓嶆槸娌℃湁浜嗭紝鏄鍦瀵煎嚭锛屽洜涓烘枃浠跺緢澶э紝杩欓噷鐪嬫槸2.041 GB锛屾墍浠ュ鍑洪渶瑕佹椂闂达紝瀵煎嚭瀹屾垚鍚庝細鏈夊鍑烘垚鍔熷瓧鏍凤紝鎴栬呭鍑烘垚鍔熸垨鏈夐棶棰橈紝鎴栬呭鍑轰笉鎴愬姛锛屼綘鐜板湪杩欎釜灏辨槸杩樻病瀵煎畬锛屼綘澶潃鎬ヤ簡銆傚鏋滃鍑烘垚鍔燂紝閭ｄ箞瀵煎叆鏄病鏈夐棶棰樼殑锛屽綋鐒跺彲鑳介渶瑕佸缓绔嬬敤鎴蜂粈涔堢殑锛屾垜閬囧埌杩囧鍏ユ椂鎶ユ病鏈夌敤鎴凤紝娌℃湁琛ㄧ┖闂磋繖绫...
绛旓細expdp鏈夊帇缂╂ā寮忋佷笉鍘嬬缉妯″紡涓ょ锛氫笉鍘嬬缉妯″紡灏辨槸鏁版嵁鏈夊灏戯紝鏂囦欢灏辨湁澶氬ぇ锛岄熷害蹇紝杩欐槸浠ョ┖闂存崲鏃堕棿銆傚帇缂╂ā寮瀵煎嚭鏂囦欢浼氭瘮涓嶅帇缂╂ā寮忓皬1/3锝2/3锛屼絾鏄鍑洪熷害浼氭參浜涳紝杩欐槸浠ユ椂闂存崲绌洪棿銆
绛旓細娴嬭瘯瀵煎嚭2鍒嗘枃浠 涓浠芥槸鐢╡xpdp瀵煎嚭锛屼竴浠芥槸鐢╡xp瀵煎嚭 expdp system/redhat dumpfile=rmantest.dmp directory=orabak tables=rmantest.tt exp system/redhat file=/orabak/exprman.dmp tables=rmantest.tt 鐒跺悗鐢╱ltraedit缂栬緫宸ュ叿鎵撳紑杩2涓枃浠讹紒
