|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
|PDF · Mobi · ePub|
See Also:CREATE DIRECTORY for information on creating a directory
To drop a directory, you must have the
DIRECTORY system privilege.
Caution: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.
DROP DIRECTORY bfile_dir;
See Also:"Creating a Directory: Examples"