ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 475
ORA-29283: invalid file operation
This problem is encountered when you try to import a data-pump dump file.
Actually, it is somewhere related to permission issues and also due to mismatch of the steps performed during import operation.
Actually, it is somewhere related to permission issues and also due to mismatch of the steps performed during import operation.
You can Check you permission by below command :
select * from all_directories where directory_name = ‘DIRECTORY_NAME‘;select * from user_tab_privs
where table_name = ‘DIRECTORY_NAME‘;select * from user_sys_privs
where privilege = 'CREATE ANY DIRECTORY';
Check the Below Steps :
1) Create data-pump directory
CONN / AS SYSDBACREATE OR REPLACE DIRECTORY test_dir AS '';
2.) Grant permission now to this directory
GRANT READ, WRITE ON DIRECTORY test_dir TO ;
3.)Copy the desired dump-file at directory Location :
4.)Start import now .
Good Luck
Thank you
Osama mustafa
Technology Geek 
But i want to import some tables from other db using network_link option. To do that i have read that no dumpfile is required.. Is that right? How can i proceed ? Thank you
LikeLike
Thanks for sharing the information Ocp Certification in Noida
LikeLike