Create a directory in Oracle

Generally, creating a directory in Oracle is to use a Data Pump to import/export data. In fact, directory has many other functions, this article does not elaborate 1. CREATE [or replace] directory DIRECTORY directory AS 'pathname' syntax for creating a directory; for example: create or replace directory dump_dir as 'd: \ dump \ dir' sets directory d: \ dump \ dir to directory represented by dump_dir 2. Queries which directoryselect * from dba_directories 3. Authorizes grant read, write on directory dump_dir to user014, delete drop directory dump_dir