|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
DIRECTORY statement to remove a directory object from the database.
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 removes the directory object but does not delete the associated operating system directory on the server's file system.
The following statement drops the directory object