CrazyEngineers
CrazyEngineers

  • Oracle: How to export .dmp file?

    ramana_slv

    Member

    Updated: Oct 22, 2024
    Views: 1.0K
    How export .dmp file into the database(oracle)?
    please tell me..............
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • Reya

    Member • Sep 17, 2010

    command used to export a .dmp file

    exp SYSTEM/passwd FULL=y FILE=database_export.dmp GRANTS=y ROWS=y

    check it out..
    Are you sure? This action cannot be undone.
    Cancel

  • ramana_slv

    Member • Sep 18, 2010

    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..............
    Are you sure? This action cannot be undone.
    Cancel

  • Reya

    Member • Sep 19, 2010

    can u tell me what error you got?so that i can solve your problem..
    Are you sure? This action cannot be undone.
    Cancel

  • Manish Goyal

    Member • Sep 19, 2010

    can you post the error and method you are using?
    Are you sure? This action cannot be undone.
    Cancel

  • ramana_slv

    Member • Sep 20, 2010

    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 .....................
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register