Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
Use the DROP
DIRECTORY
statement to remove a directory object from the database.
See Also:
CREATE DIRECTORY for information on creating a directory |
To drop a directory, you must have the DROP
ANY
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. |
drop_directory::=
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 bfile_dir
:
DROP DIRECTORY bfile_dir;