数据库dmp文件怎么导入mysql,如何从dmp文件和日志文件导入Oracle数据库？

How would I go about to create a database from a dmp-file? I do not have an existing database with the same structure on my system so it has to be complete with jobs, events, tables and so on.

I placed dmp and log file in E: drive

I have tried the import utility

E:/>impdp system/tiger@oratest FILE=WB_PROD_FULL_20MAY11.dmp

But I'm getting error as

invalid argument value

bad dump file specification

unable to open dump file "E:\app\Vensi\admin\oratest\dpdump\WB_PROD_F

ULL_20MAY11.dmp" for read

unable to open file

unable to open file

(OS 2) The system cannot find the file specified.

And when I see in Windows Explorer dmp file(taken from Linux server) is showing as Crash dump file

I donot understand how I can resolve this issue. Please help me to solve this issue.

I'm a complete newbie on Oracle...

解决方案

How was the database exported?

If it was exported using exp and a full schema was exported, then

Create the user:

create user identified by default tablespace quota unlimited on ;

Grant the rights:

grant connect, create session, imp_full_database to ;

Start the import with imp:

imp /@ file=.dmp log=.log full=y;

If it was exported using expdp, then start the import with impdp:

impdp / directory= dumpfile=.dmp logfile=.log full=y;

Looking at the error log, it seems you have not specified the directory, so Oracle tries to find the dmp file in the default directory (i.e., E:\app\Vensi\admin\oratest\dpdump\).

Either move the export file to the above path or create a directory object to pointing to the path where the dmp file is present and pass the object name to the impdp command above.