How to create Directory

let's check out create directory syntax .


SQL> CREATE OR REPLACE DIRECTORY TEST_DIR AS '/scratch/Dump_CBA';

Directory created

SQL> grant read,write,execute on directory TEST_DIR to SCOTT;

Grant succeeded

SQL> select * from all_directories where directory_name='TEST_DIR';

OWNER                          DIRECTORY_NAME                 DIRECTORY_PATH
------------------------------ ------------------------------ -------------------------------------------------------------
SYS                            TEST_DIR                                     /scratch/Dump_CBA