ToadforOracle(青蛙)手動(dòng)導(dǎo)入Oracle的.dmp文件方法

1、ToadforOracle（青蛙）手動(dòng)錄入Oracle的.DMP文件方法以管理員身份登陸Toad:已經(jīng)創(chuàng)建用戶的必須先為用戶設(shè)定管理權(quán)限）選擇Importusers點(diǎn)擊進(jìn)入下一步五、點(diǎn)擊下一步進(jìn)入至如下窗體，按示例勾選響應(yīng)的框，點(diǎn)擊下iH.步LoadsettingsSavesettingsPreviewNextCancelD:QradeTDSOVoadforOradeJseImportUtilityWizard曲ToadZforOracleFileEditSearchGridEditorSessionDatabaesDebugViewUtilitieseBcWindow旦曲/FJSQXJSQK

2、+”b圮aieProjectManager4XjTrash匚呂nTOADprojectJSQXJ下一步，選擇自己下邊的ParameterfileiH.步,Toad?forOracle醴JSQXJSQX-ImportUtilityWizardSelectwhichobjectstoimportVGrantsFTIndexes1=1F71Tablerows0Constraints8.1orabove)RecordI已ngthisusediftheExportfibisfromanotheroperatingsystemwithadifferentdefaultvalueLeaveblnktouse

3、platformsBUFSIZvalue.RecordI已ngth:;KBSelectadditionaloptionSjoracceptdefaultsF71Reuseexistingd日tafilesF71IgnoreerrorsCommitaftereacharrayinsertShowexportfilecententaonlyBuffersize(leaveblnkfordefault):1000KBrowsareimportedProvideafeedbackdoteachtime由其他oracle備份出來的DMP文件，此時(shí)的Logfilename:yu與name都會(huì)自動(dòng)獲取響應(yīng)的

4、路徑FileEditSearchGridEditorSessionDatabaesDebugViewUtilitieseBizWindow旦elp星耄譜君驚書BO-您Et&tk-i丿FJSQXJSQXProjectManager4X+kbaiejTrash匚呂nTOADprojectJSQX點(diǎn)擊進(jìn)入下一步,點(diǎn)選Importnow進(jìn)D:oradeTDSOToadfbrOradeUse醴JSQXJSQX-ImportUtilityWizardI1=1叵）Entertheexportfilename.Youmayoptionallychoosealogfilename(recommended)andafiletncaptureindexcreationcommands.Logfilename:Indexfile:D:jsqximpjsqxogTheparameterfilewillbegeneratedbythewizardandpassedasaparametertothe