CREATE DIRECTORY for information on creating a directory
To drop a directory, you must have the
DIRECTORY system privilege.
Do not drop a directory when files in the associated file system are being accessed by PL/SQL or OCI programs.
Specify the name of the directory database object to be dropped.
Oracle Database removes the directory object but does not delete the associated operating system directory on the server file system.
Dropping a Directory: Example
The following statement drops the directory object
DROP DIRECTORY bfile_dir;