一台服务器上有两个oracle，用户名一样，怎么用empdp导出指定的库的指定的用户里面全部数据 如何把一个服务器上的Oracle数据导入到另一个Oracle...
\u4e00\u4e2a\u670d\u52a1\u5668\u4e0a\u6709\u4e24\u4e2aoracle\u5b9e\u4f8b\uff0cservicename\u5206\u522b\u4e3aA\u548cB\uff0c\u600e\u4e48\u767b\u5f55\u5230\u4e0d\u540c\u7684oracle\u6570\u636e\u5e93\u554a\u3002\u3002\u30021\u3001\u9ed8\u8ba4\u5e94\u8be5\u662f\u73af\u5883\u53d8\u91cfORACLE_SID\u8bbe\u7f6e\u7684\uff0c\u4f60\u53ef\u4ee5\u4fee\u6539\u73af\u5883\u53d8\u91cf\u518d\u767b\u9646
2\u3001\u6216\u8005sqlplus /nolog
SQL> conn user/password@SID
3\u3001\u67e5\u770b\u6570\u636e\u5e93\u6709\u54ea\u4e9b\u7528\u6237
SQL> select username,account_status from dba_users;
1\u3001\u7528exp,\u7136\u540e\u5728\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u4e2dimp\u3002\u4e0d\u9002\u7528\u4e8e\u4ece\u4f4e\u7248\u672c\u5230\u9ad8\u7248\u672c\u7684\u5bfc\u5165\u3002
2\u3001\u5728\u4e00\u4e2a\u6570\u636e\u5e93\u4e2d\uff0c\u7528PL/SQL\u4ece\u8868\u4e2d\u5bfc\u51fa\u6570\u636e\uff0c\u53ef\u751f\u6210SQL\u811a\u672c\u6216\u6587\u672c\u6570\u636e\uff1b\u7136\u540e\u5728\u7528PL/SQL\u8fde\u4e0a\u53e6\u4e00\u6570\u636e\u5e93\u8fdb\u884c\u5bfc\u5165\u6570\u636e\u3002
3\u3001\u5efa\u7acbdblink,\u7136\u540e insert table
select * from table@db1;
1.创建directory
SQL> CREATE DIRECTORY DUMPDIR AS 'D:\BACKUP';
2.授权用户对directory有读写权限；
SQL> GRANT READ,WRITE ON DIRECTORY DUMPDIR TO myuser;
3.导出数据。
C:\Users\Administrator>EXPDP myuser/[email protected]:1521/ORCL DIRECTORY=DUMPDIR DUMPFILE=TESTREPORT.DMP FULL=Y
好玩
expdp user/pswd@oraclesid .....
绛旓細Oracle鏁版嵁搴鐨勫揩鐓ф槸涓涓〃锛屽畠鍖呭惈鏈夊涓涓湰鍦版垨杩滅▼鏁版嵁搴撲笂涓涓垨澶氫釜琛ㄦ垨瑙嗗浘鐨勬煡璇㈢殑缁撴灉銆備篃灏辨槸璇村揩鐓ф牴鏈殑鍘熺悊灏辨槸灏嗘湰鍦版垨杩滅▼鏁版嵁搴涓婄殑涓涓煡璇㈢粨鏋滀繚瀛樺湪涓涓〃涓備互涓嬫槸鎴戝缓绔嬬殑Snapshot锛岀洰鐨勬槸浠庝笟鍔℃暟鎹簱涓婂皢鏁版嵁Copy鍒板鐞嗘暟鎹簱涓婏紝鏄笉鍚鐨勪袱涓湇鍔″櫒涔嬮棿瀵规暟鎹甤opy銆傜涓...
绛旓細濡傛灉鏄痳ac鐨勬暟鎹悓姝ラ偅鏄氳繃濡備笅杩涚▼鍚屾鐨勶細1.鏌愪釜鑺傜偣浠庡叡浜暟鎹簱涓鍙栦竴涓猙lock鍒癲b cache涓 2.杩欎釜鑺傜偣浼氬湪鎵鏈夌殑鑺傜偣杩涜浜ゅ弶db block copy 3.褰撲换浣曚竴涓妭鐐圭殑缂撳瓨琚慨鏀圭殑鏃跺欙紝灏变細鍦ㄨ妭鐐逛箣闂磋繘琛岀紦瀛樹慨鏀 4.灏嗘渶缁堜慨鏀圭殑缁撴灉鍐欏埌纾佺洏涓 鍏朵粬鐨勬敮鎸涓ゅ彴鏁版嵁搴鏈嶅姟鍣鍚屾鐨勬柟寮忓緢澶氾細濡傞珮绾...
绛旓細1銆佹暟鎹噺涓嶅ぇ鐨勮瘽锛屾瘮濡傛暣浣撳皬浜10G锛屼綘鍙互鍦ㄤ富鏈鸿闂噺灏忔椂鎴栬卻hutdown鏃跺皢oracle鎵撳寘銆備緥濡傦細tar zcf /opt/u02.gz /u02锛岀劧鍚庡皢u02.gz鏂囦欢scp鍒板鏈恒2銆佸鏋滄暟鎹噺寰堝ぇ锛屼綘鍙互鐢╮sync鍚屾鍒板鏈 3銆侀厤缃富澶囨棤瀵嗙爜浜掕 4銆佹坊鍔犺鍒掍换鍔 crontab -e 0 4 * * * /opt/rsync_ora.sh;r...
绛旓細涓や釜涓鏍鐨刼racle 锛屽畾鏈熷悓姝ワ紝璇寸櫧浜嗗氨鏄富澶囩敤鏁版嵁搴撴暟鎹悓姝ョ殑闂锛涘鏋滄暟鎹簱A鍜屾暟鎹簱B鏄缓绔嬪湪涓ゅ彴鐙珛鐨勬暟鎹簱鏈嶅姟鍣ㄤ笂锛岄偅涔堥噰鐢╠blink鏂瑰紡鏄竴绉嶅彲琛岀殑鏂瑰紡锛岀涓绉嶆柟寮忥細鍓嶆彁鏄暟鎹簱A鍜屾暟鎹簱B鏈湴缃戞槸24灏忔椂浜掗氱殑鍚屾椂瀵规暟鎹悓姝ュ疄鏃舵ф湁姣旇緝楂樼殑瑕佹眰锛岄偅涔堝彲浠ュ缓绔婦BLINK锛屽湪涓や釜搴撻兘寤...
绛旓細棣栧厛鍦ORACLE_B涓婂仛dblink杩炴帴ORACLE_A锛岀劧鍚庡仛涓瓨鍌ㄨ繃绋嬶紝澶ц嚧濡備笅锛氭壘鍒皌able_db涓婚敭锛宻elect 涓婚敭 from table_db@dblink minus select table_db from table_db鎵惧埌宸紓鏁版嵁锛岀劧鍚庢彃鍏ュ埌oracle_b锛屽啀鍐欎釜job.瀹氭椂鎵ц杩欎釜瀛樺偍杩囩▼
绛旓細鍙兘浣跨敤dblink浜嗐俢reate database link xxx connect to B identified by 瀵嗙爜 using '127.0.0.1:绔彛鍙/sid' ;鍒涘缓鍚巃鐢ㄦ埛浣跨敤 select * from 琛ㄥ悕@xxx 鍗冲彲璁块棶鍙﹀涓涓疄渚婤鐢ㄦ埛涓嬬殑琛ㄤ簡銆
绛旓細鍏堝湪b涓婂缓涓涓猟blink 姣斿鍙玜link 浣犲彲浠ュ厛鍋氫釜澶囦唤create table btest1_bak as select * from btest1 鐒跺悗insert into btest1_bak select * from atest2@alink t where not exists(select 1 from btest1_bak where 瀛楁1=t.瀛楁1 and 瀛楁2=t.瀛楁2銆傘傘)鐒跺悗鐪嬪涓嶅 濡傛灉姝ｇ‘ 灏辨搷浣...
绛旓細鏁版嵁搴撻兘鍙互璁剧疆閾炬帴锛屽锛歴elect * from [servername].database.table
绛旓細\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora涓洿鎺ユ坊鍔犻厤缃潵瀹屾垚,鎴栬呴氳繃鍛戒护:寮濮--杩愯--cmd---netca,寮瑰嚭鐨勭獥鍙ｄ腑閫夋嫨鏈湴net鏈嶅姟鍚嶉厤缃,鎸夌収鎻愮ず閰嶇疆灏監K.鏂规硶鏈夊緢澶氱.
绛旓細锛2锛夎兘涓嶈兘鍋氾紵鑳藉仛锛屼絾鏄垜杩樻槸閭ｄ箞璇达紝涓嶅缓璁仛銆涓鍙版湇鍔″櫒锛屼袱涓暟鎹簱銆傝繖涓鏈変袱涓鍔炴硶锛氱涓涓姙娉曟槸瑁呬竴鍙拌櫄鎷熸満锛屾垨鑰呭皢B鏈嶅姟鍣ㄥ垎鏈猴紙灏辨槸涓鍙板彉涓ゅ彴锛岃繖涓槸鏈嶅姟鍣ㄦ柟闈㈢殑鎶鏈紝涓嶈繃鏈哄櫒涓瀹氳澶熺‖澶熷己锛屼笉鐒舵ц兘涓婄殑褰卞搷闈炲父澶э級锛岀劧鍚庢瘡涓垎鏈轰笂鍒嗗埆瑁呬竴涓猳racle锛堜篃鍙互鐪熷疄鏈轰竴涓紝...
