DROP DIRECTORY

Syntax

Purpose

Use DROP DIRECTORY to remove a directory object from the database.

For information on creating a directory, see "CREATE DIRECTORY".

Prerequisites

To drop a directory you must have the DROP ANY DIRECTORY system privilege.

WARNING: Do not drop a directory when files in the associated file system are being accessed by PL/SQL or OCI programs.

Keywords and Parameters

directory_name

is the name of the directory database object to be dropped. Oracle removes the directory object, but does not delete the associated operating system directory on the server's file system.

Example

The following statement drops the directory object BFILE_DIR:

DROP DIRECTORY bfile_dir;