ORA-39087: directory name string is invalid

Answers were Sorted based on User's Feedback



ORA-39087: directory name string is invalid..

Answer / guest

Cause: A corresponding directory object does not exist.

Action: Correct the directory object parameter, or create a
corresponding directory object with the CREATE DIRECTORY
command.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

ORA-39087: directory name string is invalid..

Answer / sundeep

First you have to check whether disrectory exists, if
directory exists ..just grant READ,WRITE permission on that
directory to the SCHEMA

SQL> GRANT READ,WRITE on DIRECTORY DATA_PUMP_DIR to SYSTEM;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28157: Proxy user 'string' forbidden to set role 'string' for client 'string'

1 Answers  


ORA-24081: compatible parameter needs to be string or greater

1 Answers  


NPL-00310: ASN.1 sequence has already been ended on read

1 Answers  


NZE-28832: invalid data unit format

1 Answers  


QSM-01082: Joining materialized view, string, with table, string, not possible

1 Answers  






ORA-16086: standby database does not contain available standby log files

1 Answers  


ORA-12574: TNS:redirection denied

1 Answers  


TNS-04022: %s parameter string set to string.

1 Answers  


NNO-00317: statistic counter reset interval changed to number seconds

1 Answers  


TNS-00141: Failed to get file stream information

1 Answers  


ORA-32801: invalid value string for string

1 Answers  


QSM-01011: when heuristic rewrite not set, rewrite hint required

1 Answers  


Categories