CREATE [ OR REPLACE ] DIRECTORY directory AS 'path_name' ;

 
SQL> CREATE OR REPLACE DIRECTORY DB_EXPORT AS 'C:\EXPORT\';

Directory created.

SQL> GRANT READ, WRITE ON DIRECTORY DB_EXPORT TO scott;

Grant succeeded.

SQL> COLUMN OWNER FORMAT A10
SQL> COLUMN DIRECTORY_NAME FORMAT A20
SQL> COLUMN DIRECTORY_PATH FORMAT A40
SQL> SELECT * FROM all_directories;

OWNER      DIRECTORY_NAME       DIRECTORY_PATH
---------- -------------------- ----------------------------------------
SYS        KEYDIR               C:\WINDOWS
SYS        DB_EXPORT            C:\EXPORT\

4 rows selected.

SQL>