Import of .dmp file not happening

67 Views Asked by At

I have created a Directory D44

CREATE DIRECTORY D44 AS 'C:/Users/Siddharth/Oracle_dump_files';

and given it access through another user using this command

grant read,write on directory D44 to FINANCE9;

But now when I am trying to import .dmp files along with the log files it is throwing the below errors

Command used and erros:

C:\Users\Siddharth>impdp FINANCE9/FIN123 schemas=FINANCEV1 directory=D44 dumpfile=APD_FY23_Q1_FINAL.DMP REMAP_SCHEMA=FINANCEV1:FINANCE9 logfile=APD_FY23_Q1_FINAL.log

Import: Release 12.2.0.1.0 - Production on Mon Feb 27 17:12:23 2023

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-29283: invalid file operation

Please help me in reading the .dmp files

1

There are 1 best solutions below

0
Javier Bordonada On

Try doing an export of a table for that user to check that the directory was created correctly, in my opinion, you are writing the directory wrong using slashes instead of backslashes, but since I don't work with oracle on windows I can't be sure.