# Look for ORA-27037, ORA-27041, etc. grep -i "unable to create" /u01/app/oracle/diag/rdbms/*/trace/alert*.log Run this as SYSDBA to diagnose:
GRANT READ, WRITE ON DIRECTORY your_dir TO your_user; Wrong examples:
# Using a literal path instead of directory object name expdp user/pass directory=/u01/dumpfile dumpfile=exp.dmp # WRONG expdp user/pass dumpfile=/u01/dumpfile/exp.dmp # WRONG
# Check owner and permissions ls -ld /path/to/your/directory chown oracle:dba /path/to/your/directory Set correct permissions chmod 775 /path/to/your/directory Step 4: Validate Directory Object Permissions in Oracle Grant necessary privileges to the schema doing the export:
# Look for ORA-27037, ORA-27041, etc. grep -i "unable to create" /u01/app/oracle/diag/rdbms/*/trace/alert*.log Run this as SYSDBA to diagnose:
GRANT READ, WRITE ON DIRECTORY your_dir TO your_user; Wrong examples: # Look for ORA-27037, ORA-27041, etc
# Using a literal path instead of directory object name expdp user/pass directory=/u01/dumpfile dumpfile=exp.dmp # WRONG expdp user/pass dumpfile=/u01/dumpfile/exp.dmp # WRONG # Look for ORA-27037
# Check owner and permissions ls -ld /path/to/your/directory chown oracle:dba /path/to/your/directory Set correct permissions chmod 775 /path/to/your/directory Step 4: Validate Directory Object Permissions in Oracle Grant necessary privileges to the schema doing the export: WRITE ON DIRECTORY your_dir TO your_user