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-36954: (XSFCAST24) The cycle number must be between 1 and number. You specified number.

1 Answers  


ORA-19036: Invalid query result set in newContextFromHierarchy()

1 Answers  


ORA-08106: cannot create journal table string.string

1 Answers  


ORA-16127: stalled waiting for additional transactions to be applied

1 Answers  


PLS-00140: duplicate external LIBRARY specification in subprogram expression

1 Answers  






IMG-00560: input format does not support page selection

1 Answers  


ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals

1 Answers  


RMAN-08529: proxy file handle=string

1 Answers  


ORA-13370: failure in applying 3D LRS functions

1 Answers  


ORA-13633: The task string was interrupted and needs to be resumed.

1 Answers  


NPL-00302: ASN.1 type tag is greater than maximum of 16383

1 Answers  


PLS-00647: attribute by name "string" conflicts with method by same name

1 Answers  


Categories