Tag Archives: expdp

ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, ORA-29283: invalid file operation

When doing export occur above error, let’s check directories:

SQL> select directory_name, directory_path from dba_directories
DIRECTORY_NAME     DIRECTORY_PATH
——————————————————————————–
DUMP_DIR       /u02/dump_dir

Two thing’s that hadn’t done is:
1) given correct permissions for that user to acccess the logical directory for export:

SQL> GRANT read, write on directory dump_dir TO ika; <-- userrname

2) create the physical directory

[oracle@oel6]$ mkdir -p /u02/dump_dir

after that our export run successfully;

killing – stopping expdp/impdp processes

Sometimes it’s really need to killing expdp or impdp processes because wrong import or export, or heavy load on database or many other situation.
1) you need to identify job name, which you can view in data dictionary views:

select * from USER_DATAPUMP_JOBS;
select * from DBA_DATAPUMP_SESSIONS;

2) you need to attach that job find in above views:

impdp system/***** attach=test_dump(job_name)

3) stop job with command:

STOP_JOB=IMMEDIATE

That’s all.