Some issue when working on a datapump on an old machine. It used to work and out of a sudden, I was getting errors.
C:\Windows\system32>expdp bobdb/vmware dumpfile=bobdb.dmp full=n directory=DMPDIR logfile=bobdb.export.log
Export: Release 11.2.0.1.0 - Production on Thu Oct 15 10:16:07 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
UDE-28002: operation generated ORACLE error 28002
ORA-28002: the password will expire within 7 days
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
C:\Windows\system32>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 15 10:16:28 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select directory_name, directory_path from dba_directories;
DIRECTORY_NAME
------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
XMLDIR
c:\ade\aime_dadvfm0254\oracle\rdbms\xml
DMPDIR
C:\Users\orcldb\Downloads\bobdb\
DATA_PUMP_DIR
C:\app\orcldb\admin\zig\dpdump\
DIRECTORY_NAME
------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
ORACLE_OCM_CONFIG_DIR
C:\app\orcldb\product\11.2.0\dbhome_2\ccr\state
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Windows\system32>
It turned out, entire directory of "C:\Users\orcldb\Downloads\bobdb\" was removed and causing the error. I wish the error would me more intuitive.
Created "bobdb" under download and fixed the issue.
