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导出