如何导oracle数据库
oracle \u6570\u636e\u5bfc\u5165\u6211\u7ed9\u4f60\u4e00\u4e9b\u6570\u636e\u5e93\u5e38\u7528\u7684\u5bfc\u5165\u5bfc\u51fa\u547d\u4ee4\u5427:
\u8be5\u547d\u4ee4\u5728\u201c\u5f00\u59cb\u83dc\u5355>>\u8fd0\u884c>>CMD\u201d\u4e2d\u6267\u884c
\u4e00\u3001\u6570\u636e\u5bfc\u51fa\uff08exp.exe\uff09
1\u3001\u5c06\u6570\u636e\u5e93orcl\u5b8c\u5168\u5bfc\u51fa\uff0c\u7528\u6237\u540dsystem\uff0c\u5bc6\u7801accp\uff0c\u5bfc\u51fa\u5230d:\daochu.dmp\u6587\u4ef6\u4e2d
exp system/accp@orcl file=d:\daochu.dmp full=y
2\u3001\u5c06\u6570\u636e\u5e93orcl\u4e2dscott\u7528\u6237\u7684\u5bf9\u8c61\u5bfc\u51fa
exp scott/accp@orcl file=d:\daochu.dmp owner=(scott)
3\u3001\u5c06\u6570\u636e\u5e93orcl\u4e2d\u7684scott\u7528\u6237\u7684\u8868emp\u3001dept\u5bfc\u51fa
exp scott/accp@orcl file= d:\daochu.dmp tables=(emp,dept)
4\u3001\u5c06\u6570\u636e\u5e93orcl\u4e2d\u7684\u8868\u7a7a\u95f4testSpace\u5bfc\u51fa
exp system/accp@orcl file=d:\daochu.dmp tablespaces=(testSpace)
\u4e8c\u3001\u6570\u636e\u5bfc\u5165\uff08imp.exe\uff09
1\u3001\u5c06d:\daochu.dmp \u4e2d\u7684\u6570\u636e\u5bfc\u5165 orcl\u6570\u636e\u5e93\u4e2d\u3002
imp system/accp@orcl file=d:\daochu.dmp full=y
2\u3001\u5982\u679c\u5bfc\u5165\u65f6\uff0c\u6570\u636e\u8868\u5df2\u7ecf\u5b58\u5728\uff0c\u5c06\u62a5\u9519\uff0c\u5bf9\u8be5\u8868\u4e0d\u4f1a\u8fdb\u884c\u5bfc\u5165\uff1b\u52a0\u4e0aignore=y\u5373\u53ef\uff0c\u8868\u793a\u5ffd\u7565\u73b0\u6709\u8868\uff0c\u5728\u73b0\u6709\u8868\u4e0a\u8ffd\u52a0\u8bb0\u5f55\u3002
imp scott/accp@orcl file=d:\daochu.dmp full=y ignore=y
3\u3001\u5c06d:\daochu.dmp\u4e2d\u7684\u8868emp\u5bfc\u5165
imp scott/accp@orcl file=d:\daochu.dmp tables=(emp)
1 \u5c06\u6570\u636e\u5e93TEST\u5b8c\u5168\u5bfc\u51fa,\u7528\u6237\u540dsystem \u5bc6\u7801manager \u5bfc\u51fa\u5230D:\daochu.dmp\u4e2d
exp system/manager@TEST file=d:\daochu.dmp full=y
2 \u5c06\u6570\u636e\u5e93\u4e2dsystem\u7528\u6237\u4e0esys\u7528\u6237\u7684\u8868\u5bfc\u51fa
exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
3 \u5c06\u6570\u636e\u5e93\u4e2d\u7684\u8868table1 \u3001table2\u5bfc\u51fa
exp system/manager@TEST file=d:\daochu.dmp tables=(table1,table2)
4 \u5c06\u6570\u636e\u5e93\u4e2d\u7684\u8868table1\u4e2d\u7684\u5b57\u6bb5filed1\u4ee5"00"\u6253\u5934\u7684\u6570\u636e\u5bfc\u51fa
exp system/manager@TEST file=d:\daochu.dmp tables=(table1) query=\" where filed1 like '00%'\"
\u4e0a\u9762\u662f\u5e38\u7528\u7684\u5bfc\u51fa\uff0c\u5bf9\u4e8e\u538b\u7f29\u6211\u4e0d\u592a\u5728\u610f\uff0c\u7528winzip\u628admp\u6587\u4ef6\u53ef\u4ee5\u5f88\u597d\u7684\u538b\u7f29\u3002
\u4e0d\u8fc7\u5728\u4e0a\u9762\u547d\u4ee4\u540e\u9762 \u52a0\u4e0a compress=y \u5c31\u53ef\u4ee5\u4e86
1)按用户导
expdp scott/tiger@orcl schemas=scott dumpfile=expdp.dmp DIRECTORY=dpdata1;
2)并行进程parallel
expdp scott/tiger@orcl directory=dpdata1 dumpfile=scott3.dmp parallel=40 job_name=scott3
3)按表名导
expdp scott/tiger@orcl TABLES=emp,dept dumpfile=expdp.dmp DIRECTORY=dpdata1;
4)按查询条件导
expdp scott/tiger@orcl directory=dpdata1 dumpfile=expdp.dmp Tables=emp query='WHERE deptno=20';
5)按表空间导
expdp system/manager DIRECTORY=dpdata1 DUMPFILE=tablespace.dmp TABLESPACES=temp,example;
6)导整个数据库
expdp system/manager DIRECTORY=dpdata1 DUMPFILE=full.dmp FULL=y;
五、还原数据
1)导到指定用户下
impdp scott/tiger DIRECTORY=dpdata1 DUMPFILE=expdp.dmp SCHEMAS=scott;
2)改变表的owner
impdp system/manager DIRECTORY=dpdata1 DUMPFILE=expdp.dmp TABLES=scott.dept REMAP_SCHEMA=scott:system;
3)导入表空间
impdp system/manager DIRECTORY=dpdata1 DUMPFILE=tablespace.dmp TABLESPACES=example;
4)导入数据库
impdb system/manager DIRECTORY=dump_dir DUMPFILE=full.dmp FULL=y;
5)追加数据
impdp system/manager DIRECTORY=dpdata1 DUMPFILE=expdp.dmp SCHEMAS=system TABLE_EXISTS_ACTION=append;
exp 是导出命令
imp是导入命令
imp system/manager@服务SID file=bible_db.dmp full=y ignore=y fromuser=a touser=b
fromuser是你导出时用的用户
touser是你要导入到的那个用户 并不一定是你使用导入时的这个用户
你那个文件夹是做什么的？要导入的只有dmp文件吧
绛旓細1銆侀鍏堟墦寮PL/SQLDeveloper锛岃緭鍏ョ敤鎴峰悕銆佸瘑鐮佺櫥褰oracle鏁版嵁搴銆2銆併愬鍑 - 1銆戠偣鍑婚《閮ㄨ彍鍗曘怲ools銆->銆怑xport Tables銆戙3銆佺劧鍚庨夋嫨瑕佸鍑虹殑鐢ㄦ埛锛堥粯璁ゆ槸褰撳墠鐧诲綍鐨勭敤鎴凤級锛岀偣鍑汇怬utput file銆戝悗闈㈢殑鏂囦欢澶瑰浘鏍囷紝閫夋嫨鏁版嵁搴撳鍑烘枃浠跺瓨鏀句綅缃笌瀵煎嚭鏂囦欢鐨勫悕瀛椼4銆佸湪銆愬湪瀵煎嚭琛ㄧ晫闈戦変腑琛ㄥ悕锛屽彲...
绛旓細exp鍛戒护鐢ㄤ簬鎶婃暟鎹粠杩滅▼鏁版嵁搴撴湇鍔″櫒瀵煎嚭鑷虫湰鍦,鐢熸垚dmp鏂囦欢;imp鍛戒护鐢ㄤ簬鎶婃湰鍦扮殑鏁版嵁搴揹mp鏂囦欢浠庢湰鍦板鍏ュ埌杩滅▼鐨凮racle鏁版嵁搴撲腑銆備簩.璇硶鍙互閫氳繃鍦ㄥ懡浠よ杈撳叆 imp help=y 鑾峰彇imp鐨勮娉曚俊鎭:===C:Documents and Settingsauduser>imp help=yImport: Release 9.0.1.1.1 - Production on 鏄熸湡浜...
绛旓細鎴戜竴鑸涓嬪鐞嗭細绗竴姝ュ湪oracle鏁版嵁涓缓涓涓悓鏋勭殑琛;绗簩姝ュ悗鍦╬l/sqldeveloper涓敤select*fromtbl_namewhere1=0forupdate鐨勮鍙ワ紝杩涜缂栬緫 绗笁姝opyexcel鐨勫唴瀹癸紝濡傛灉excel鏈夋爣棰樿锛岄渶瑕佸垹闄よ琛;娉ㄦ剰锛宔xcel琛ㄦ牸鍓嶈鏈変竴涓┖琛屼笖鍜宱racle琛ㄥ垪椤哄簭涓鑷 绗洓姝ュ湪pl/sqldeveloper涓矘璐;濡傛灉绗竴娆...
绛旓細鎴戠粰浣犱竴浜鏁版嵁搴甯哥敤鐨勫鍏ュ鍑哄懡浠ゅ惂:\x0d\x0a璇ュ懡浠ゅ湪鈥滃紑濮嬭彍鍗>>杩愯>>CMD鈥濅腑鎵ц\x0d\x0a涓銆鏁版嵁瀵鍑(exp.exe)\x0d\x0a1銆佸皢鏁版嵁搴搊rcl瀹屽叏瀵煎嚭,鐢ㄦ埛鍚峴ystem,瀵嗙爜accp,瀵煎嚭鍒癲:\daochu.dmp鏂囦欢涓璡x0d\x0aexp system/accp@orcl file=d:\daochu.dmp full=y\x0d\x0a\x0d\x0a2...
绛旓細1銆 鍑嗗鏁版嵁搴鍒涘缓鑴氭湰?create tablespace whc_tbs datafile 鈥楨:\oracle\oradata\whcdb\whc.dbf鈥 size 100M;--DROP TABLESPACE whc_tbs INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;create user whc identified by whc default tablespace whc_tbs;grant connect,resource to whc; grant ...
绛旓細2. 閫氳繃oracle鎻愪緵鐨凬etConfiguration Assistant杩炴帴 杩涜鏁版嵁搴瀵煎叆瀵煎嚭宸ヤ綔鐨勫厛鍐虫潯浠讹細1. 鏈湴瀹夎Oraclek瀹㈡埛绔垨鏄湇鍔″櫒绔2. 閫氳繃oracle鎻愪緵鐨凬etConfiguration Assistant杩炴帴鍒扮洰鏍囨暟鎹簱銆傜涓姝ユ瘚搴稿瑷锛岀浜屾绋嶅井瑕佽涓涓嬶紝鎵撳紑Net Configuration Assistant锛岄夋嫨绗笁椤癸紝涓嬩竴涓〉闈㈣緭鍏ヨ繙绋嬫暟鎹簱...
绛旓細鏁版嵁瀵鍑哄叿浣撳涓嬶細灏鏁版嵁搴TEST瀹屽叏瀵煎嚭,鐢ㄦ埛鍚峴ystem 瀵嗙爜manager 瀵煎嚭鍒癉:\daochu.dmp涓傚皢鏁版嵁搴撲腑system鐢ㄦ埛涓巗ys鐢ㄦ埛鐨勮〃瀵煎嚭銆傚皢鏁版嵁搴撲腑鐨勮〃table1 銆乼able2瀵煎嚭銆傚皢鏁版嵁搴撲腑鐨勮〃table1涓殑瀛楁filed1浠"00"鎵撳ご鐨勬暟鎹鍑恒傚皢D:\daochu.dmp 涓殑鏁版嵁瀵煎叆 TEST鏁版嵁搴撲腑銆傚皢d:\daochu....
绛旓細5)鎸夎〃绌洪棿瀵 expdp system/manager DIRECTORY=dpdata1 DUMPFILE=tablespace.dmp TABLESPACES=temp,example;6)瀵兼暣涓鏁版嵁搴 expdp system/manager DIRECTORY=dpdata1 DUMPFILE=full.dmp FULL=y;浜斻佽繕鍘熸暟鎹 1)瀵煎埌鎸囧畾鐢ㄦ埛涓 impdp scott/tiger DIRECTORY=dpdata1 DUMPFILE=expdp.dmp SCHEMAS=scott;2)...
绛旓細1 灏鏁版嵁搴TEST瀹屽叏瀵煎嚭,鐢ㄦ埛鍚峴ystem 瀵嗙爜manager 瀵煎嚭鍒癉:\daochu.dmp涓璡x0d\x0a exp system/manager@TEST file=d:\daochu.dmp full=y\x0d\x0a2 灏嗘暟鎹簱涓璼ystem鐢ㄦ埛涓巗ys鐢ㄦ埛鐨勮〃瀵煎嚭\x0d\x0a exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)\x0d\x0a3...
绛旓細oracle鐢╦ava缂栧啓锛孲QLPLUS.EXE銆丒XP.EXE銆両MP.EXE杩欎袱涓枃浠舵湁鍙兘鏄鍖呰鍚庣殑绫绘枃浠躲係QLPLUS.EXE璋冪敤EXP.EXE銆両MP.EXE鎵鍖呰９鐨勭被锛屽畬鎴愬鍏ュ鍑哄姛鑳姐鏁版嵁瀵鍑猴細1 灏鏁版嵁搴TEST瀹屽叏瀵煎嚭,鐢ㄦ埛鍚峴ystem 瀵嗙爜manager 瀵煎嚭鍒癉:\daochu.dmp涓 exp system/manager@TEST file=d:\daochu.dmp full=y 2...
