When i backup oracle using this statement:
EXPDP userid=scott/tiger@orcl directory=DATA_PUMP_DIR dumpfile=%filename%.DMP
It has error:
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;
the DATA_PUMP_DIR is
D:\app\Administrator\admin\orcl\dpdump\
More inportantly, I created the directory by myself. It still gives the same error and I am very sure the directories exists.
You need to grant read and write permission on directory to user for taking backup.(Assuming that you have all the rights)
GRANT read, write ON DIRECTORY data_pump_dir TO scott;
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments