I have a situation: I have a dmp file and a database with old data server crashed and the latest data we have ar in the dmp file! we managed to pull the server back but it has old data! so we need to restore from the dmp! how to import back the database from dmp file and replace all data and structure (tables schemes)...

I know it's RMAN's job but we do not have it in place, and it's urgent case!

  • 2
    What sort of dump file do you have? Do you know the command line that was used to generate it? Do you know whether it was generated using the classic export utility or the newer DataPump version? Do you know if it is a schema-level export, a full export, a tablespace-level export, or something else? Commented Apr 20, 2012 at 22:28

1 Answer 1


version, OS, tool are helping things to help you solve this.

I guess OS is Windows. version 9i. export full.

If this is the case: connect to the server, set ORACLE_HOME=/where/is/oracle/home/ set PATH=%ORACLE_HOME%/bin;%PATH% set ORACLE_SID=ORCL -> or your ORACLE_SID name

imp file=x.dmp logfile=imp_x.log full=y

imp help=y gives some clues about the commandline options.

study the errors. If there is a complaint about the dmp file, read the first few blocks. From those you can find who exported it, what type export it is and even some version info. It is a bit binary but just readable enough to get this info.


If your data has a real value for your company, hire a real dba to make a decent setup and have someone as a backup. It is easy to build a system that work happily for years and due to hardware issues suddenly become less happy. It's a pity if that costs your company the head. This is regardless for what brand of database you setup.

  • Thanks, well, they will redo the setup and put a good backup plan ;-)
    – Data-Base
    Commented Apr 24, 2012 at 9:20
  • well, than something has grown here. If you need help, drop me a line.
    – user953
    Commented Apr 24, 2012 at 19:29
  • I will if there any help needed ;-) thanks :-)
    – Data-Base
    Commented Apr 24, 2012 at 19:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.