I understand this is a cliche but while doing export dump in oracle, I am getting these errors.
I have pretty much followed almost all documentation online and did these following steps:
CREATE OR REPLACE DIRECTORY export_meta as '/C:/oracle/'; (where C/oracle is my local path)
GRANT READ,WRITE ON export_meta to HR
expdp username/password DIRECTORY=export_meta
dumpfile=hr.dmp
But getting these errors:
ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: ad "SYS.UTIL_FILE"
Can someone please tell me if this directory needs to be created on local and any idea as to why I am getting this error?
most probably your path '/C:/oracle/' is wrong (it starts with "/") try 'C:/oracle/' if this is just a copy/paste error then: 1) See which user started the oracle.exe process, most probably that user does not have access to write to that directory (to test this try to create the ora DIRECTORY in the $ORACLE_HOME folder, or to point to datafile folder). 2) the file hr.dmp should not exist in that directory when you start expdp