databaseoracle-databaseimportcommand-promptdmp

I have been using this statement in windows command prompt for importing .dmp files . what does the word 'full' mean here?

I have been using this statement in windows command prompt for importing .dmp files . what does the word 'full' mean here ?

imp me_user/password_me file='C:\Users\user\Desktop\file.dmp' full=Y
Solution

  • In Oracle Database there many schemas for example hr, scott,system and sys etc.

    If I am importing single user then i will use imp hr/hr file='C:\Users\user\Desktop\file.dmp' log=file='C:\Users\user\Desktop\hr-imp.lo

    g

    so the above statement will import only hr user.

    If I use full=y

    imp system/manager file='C:\Users\user\Desktop\file.dmp' log=file='C:\Users\user\Desktop\full-imp.log full=y

    Now all the four users(hr, scott,system and sys) will be imported automatically.