Oracle 11g dmp import. ORA-39000 / ORA-39143 Errors

Question

iam really new in oracle and databases at all. So sorry for a maybe stupid question.

Here is my problem. I have a DB export (not mine so i dont know how it was exported: are there differences?) and i want to import it with the following script:

@Echo off
Break off
Rem fullimpdp.cmd
set NLS_LANG=american_america.WE8MSWIN1252
set ORACLE_HOME=C:\Oracle\ora11
Set DUMP_HOME=C:\DBDump
set /p ORACLE_SID="Oracle_sid = "
set /p FILE="Dump file name = "
if exist %DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql del /F /Q %DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql
echo CREATE OR REPLACE DIRECTORY backup_dir AS '%DUMP_HOME%'; >%DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql
echo CREATE OR REPLACE DIRECTORY dmpdir AS '%DUMP_HOME%'; >>%DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql
echo commit; >>%DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql
echo exit    >>%DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql
set ORACLE_SID=%ORACLE_SID%
%ORACLE_HOME%\bin\sqlplus xpower/xpower @%DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql
%ORACLE_HOME%\bin\impdp xpower/xpower FULL=y DIRECTORY=backup_dir DUMPFILE=%FILE% logfile=impdp_%ORACLE_SID%.log JOB_NAME=impfull_%Oracle_sid%
if exist %DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql del /F /Q %DUMP_HOME%SetBackupDir_%ORACLE_SID%.sql
pause

But not the following errors occur:

Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
ORA-39000: bad dump file specification
ORA-39143: dump file "C:\DBDump\ev122.dmp" may be an original export dump file

What is wrong? How can i fix it in this script? And how can i import the file not using the script? I read about the imp file=filename command. but where to type it in? :)

Thank you.

BR

Answer 1

Try like this,

imp xpower/xpower FULL=y file=<file_name>.dmp log=log_file_name.log

Or you can import using system user,

imp system/<password> file=<file_name>.dmp log=log_file_name.log fromuser = <from_user_name> touser= xpower

Answer 2

importing dump file in oracle 11g

In SQL Command Line,

1. CREATE USER username IDENTIFIED BY password

2. grant dba to username;

In Command Line,

1. imp userid=username/password FULL=y FILE="D:\yourdumpfilename.dmp"

Note ..Be sure the path of your dump file .