Oracle导数 exp | imp 实践指南

文档完整版请到 http://www.docin.com/p-798928504.html 下载。

 

exp模板

userid="/ as sysdba"

file=(

exp01.dmp,exp02.dmp,exp03.dmp,exp04.dmp,exp05.dmp,exp06.dmp,exp07.dmp,exp08.dmp,exp09.dmp,exp10.dmp,exp11.dmp,exp12.dmp,exp13.dmp,exp14.dmp,exp15.dmp,exp16.dmp,exp17.dmp,exp18.dmp,exp19.dmp,exp20.dmp,exp21.dmp,exp22.dmp,exp23.dmp,exp24.dmp,exp25.dmp,exp26.dmp,exp27.dmp,exp28.dmp,exp29.dmp,exp30.dmp,exp31.dmp,exp32.dmp,exp33.dmp,exp34.dmp,exp35.dmp,exp36.dmp,exp37.dmp,exp38.dmp,exp39.dmp,exp40.dmp,exp41.dmp,exp42.dmp,exp43.dmp,exp44.dmp,exp45.dmp,exp46.dmp,exp47.dmp,exp48.dmp,exp49.dmp,exp50.dmp,exp51.dmp,exp52.dmp,exp53.dmp,exp54.dmp,exp55.dmp,exp56.dmp,exp57.dmp,exp58.dmp,exp59.dmp,exp60.dmp,exp61.dmp,exp62.dmp,exp63.dmp,exp64.dmp,exp65.dmp,exp66.dmp,exp67.dmp,exp68.dmp,exp69.dmp,exp70.dmp,exp71.dmp,exp72.dmp,exp73.dmp,exp74.dmp,exp75.dmp,exp76.dmp,exp77.dmp,exp78.dmp,exp79.dmp,exp80.dmp,exp81.dmp,exp82.dmp,exp83.dmp,exp84.dmp,exp85.dmp,exp86.dmp,exp87.dmp,exp88.dmp,exp89.dmp,exp90.dmp,exp91.dmp,exp92.dmp,exp93.dmp,exp94.dmp,exp95.dmp,exp96.dmp,exp97.dmp,exp98.dmp,exp99.dmp

)

log=exp.log

tables=(

owner.table1,

owner2.table2,

)

query="where company = '000018000000' and title like '%201210'"

rows=y

indexes=y

direct=y

recordlength=65535

buffer=102400000

resumable=y

resumable_timeout=259200

filesize=4294967295

---

imp模板

userid="/ as sysdba"

file=(

exp01.dmp,exp02.dmp,exp03.dmp,exp04.dmp,exp05.dmp,exp06.dmp,exp07.dmp,exp08.dmp,exp09.dmp,exp10.dmp,exp11.dmp,exp12.dmp,exp13.dmp,exp14.dmp,exp15.dmp,exp16.dmp,exp17.dmp,exp18.dmp,exp19.dmp,exp20.dmp,exp21.dmp,exp22.dmp,exp23.dmp,exp24.dmp,exp25.dmp,exp26.dmp,exp27.dmp,exp28.dmp,exp29.dmp,exp30.dmp,exp31.dmp,exp32.dmp,exp33.dmp,exp34.dmp,exp35.dmp,exp36.dmp,exp37.dmp,exp38.dmp,exp39.dmp,exp40.dmp,exp41.dmp,exp42.dmp,exp43.dmp,exp44.dmp,exp45.dmp,exp46.dmp,exp47.dmp,exp48.dmp,exp49.dmp,exp50.dmp,exp51.dmp,exp52.dmp,exp53.dmp,exp54.dmp,exp55.dmp,exp56.dmp,exp57.dmp,exp58.dmp,exp59.dmp,exp60.dmp,exp61.dmp,exp62.dmp,exp63.dmp,exp64.dmp,exp65.dmp,exp66.dmp,exp67.dmp,exp68.dmp,exp69.dmp,exp70.dmp,exp71.dmp,exp72.dmp,exp73.dmp,exp74.dmp,exp75.dmp,exp76.dmp,exp77.dmp,exp78.dmp,exp79.dmp,exp80.dmp,exp81.dmp,exp82.dmp,exp83.dmp,exp84.dmp,exp85.dmp,exp86.dmp,exp87.dmp,exp88.dmp,exp89.dmp,exp90.dmp,exp91.dmp,exp92.dmp,exp93.dmp,exp94.dmp,exp95.dmp,exp96.dmp,exp97.dmp,exp98.dmp,exp99.dmp

)

tables=(

table1,

table2,

)

query="where company = '000018000000' and title like '%201210'"

rows=y

log=imp.log

fromuser=CMSDATA

touser=CMSDATA

recordlength=65535

resumable=y

resumable_timeout=259200

ignore=y

buffer=102400000

CONSTRAINTS=N

---

参数

1.导什么？

FULL=N(默认N，Y则逻辑导出整个库与用户数据相关的对象，imp时默认Y）

OWNER=(user1,user2,user3) --按schema导出