ToadforOracle(青蛙)手动导入Oracle的.dmp文件方法

1、ToadforOracle（青蛙）手动录入Oracle的.DMP文件方法以管理员身份登陆Toad:已经创建用户的必须先为用户设定管理权限）选择Importusers点击进入下一步五、点击下一步进入至如下窗体，按示例勾选响应的框，点击下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文件，此时的Logfilename:yu与name都会自动获取响应的

4、路径FileEditSearchGridEditorSessionDatabaesDebugViewUtilitieseBizWindow旦elp星耄谱君驚書BO-您Et&tk-i丿FJSQXJSQXProjectManager4X+kbaiejTrash匚吕nTOADprojectJSQX点击进入下一步,点选Importnow进D:oradeTDSOToadfbrOradeUse醴JSQXJSQX-ImportUtilityWizardI1=1叵）Entertheexportfilename.Youmayoptionallychoosealogfilename(recommended)andafiletncaptureindexcreationcommands.Logfilename:Indexfile:D:jsqximpjsqxogTheparameterfilewillbegeneratedbythewizardandpassedasaparametertothe