Creating a Database Directory in Oracle

Oracle database has many features which run outside the database. For example we have external tables, Export,Import ,SQL * Loader etc. For all these features we might need a directory to place the respective files. We cannot just give the path in the statements all the times.

We have the ability to create directories in the database and point it to any where on the server.Below command can be used to create directory.

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

Example: CREATE DIRECTORY TEMP_DIR AS 'C:\Filepath\ExternalTables\Flatfiles';