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.