Skip to content

How to Resolve ORA-22930: directory does not exist

  • by

ORA-22930

Tried to grant read write privilege on a directory object to a user, but it failed with ORA-22930.

SQL> GRANT READ, WRITE ON DIRECTORY DATA_DUMP_DIR_2 TO ERPAPP;
GRANT READ, WRITE ON DIRECTORY DATA_DUMP_DIR_2 TO ERPAPP
                               *
ERROR at line 1:
ORA-22930: directory does not exist

ORA-22930 means that the directory object you specified in the statement is not existing in the database or maybe you misspelled it.

In this case, we'd like to create a new directory object for data pump.

SQL> CREATE OR REPLACE DIRECTORY DATA_DUMP_DIR_2 AS '/backup/dumps';

Directory created.
SQL> GRANT READ, WRITE ON DIRECTORY DATA_DUMP_DIR_2 TO ERPAPP;

Grant succeeded.

Leave a Reply

Your email address will not be published.