Geek Answers Handbook

Using expdp backup database

When I backup Oracle using this statement:

EXPDP userid=scott/ tiger@orcl directory=DATA_PUMP_DIR dumpfile=%filename%.DMP

Mistake:

  Ora-39002: The operation is invalid
 Ora-3970: can not open the log file
 Ora-39087: directory name DATA_PUMP_DIR is invalid

When I run:

 select * from dba_directories;

DATA_PUMP_DIR -

 D:\app\Administrator\admin\orcl\dpdump\

More importantly, I created the directory myself. This still gives the same error, and I am very sure that directories exist.

+9
oracle backup
source share
5 answers

You need to provide read and write permission in the directory for the user to back up. (Assuming you have all rights)

 GRANT read, write ON DIRECTORY data_pump_dir TO scott;
+10
source share

The error message that informs you is that the SCOTT user does not have privileges to write to DATA_PUMP_DIR .

As a DBA Launch

 grant read, write on directory DATA_PUMP_DIR to scott;
+2
source share

Is the folder D: \ app \ Administrator \ admin \ orcl \ dpdump \ a on the server? It must be accessible from Oracle server software in order to be valid, since the export is actually performed on the server, and not on the client.

+1
source share

Error : ORA-39087: directory name C: \ DUMP \ PUB is invalid

solution :

provide any directory ATGDB_EB_PUB;

create the directory YOUR_PATH as 'C: \ dump \ pub';

+1
source share

impdp user / pass12 @ETATD directory = EDWEXPORT dumpfile = NETWORK_ACTIVITY_SETT_TEMP.dmp logfile = NETWORK_ACTIVITY_SETT_TEMP.log full = y;

Import: release 12.2.0.1.0 - production on Sunday, May 12 09:42:02

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

Connected to: Oracle Database 12c Enterprise Edition, Release 12.2.0.1.0 - 64-bit ORA-39002: Invalid operation ORA-39070: Cannot open the log file. ORA-39087: EDWEXPORT directory name is invalid

-one
source share

More articles:


All Articles