Oracle: How to export .dmp file?

Replies

• 

  Reya

  command used to export a .dmp file
  
  exp SYSTEM/passwd FULL=y FILE=database_export.dmp GRANTS=y ROWS=y
  
  check it out..
• 

  ramana_slv

  hi preveena its not working yaar....................
  
  actually I know How to import and export .dmp file from the database. But that process not working errors occur now. why I don't know praveena..............
• 

  Reya

  can u tell me what error you got?so that i can solve your problem..
• 

  Manish Goyal

  can you post the error and method you are using?
• 

  ramana_slv

  Dmp file can place in the c:drive and then
  open command prompt give cmd cd\ and press enter and give cmd "exp" then
  C:\>exp
  Export: Release 10.2.0.1.0 - Production on Tue Sep 21 06:51:02 2010
  Copyright (c) 1982, 2005, Oracle. All rights reserved.
  Username:
  Password:
  when ever we gave username and password
  it asks buffer size then we press enter then it asks exported file name then we give the file name with .dmp extension
  then it asks the exported file can be placed which user then we give the user name then
  then all the files are exported to the corresponded user it give message exported successfully.But no data in the particular user.....why I don't know please tell me .....................