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.