Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Purpose
Use the DROP
DIRECTORY
statement to remove a directory object from the database.
See Also:
CREATE DIRECTORY for information on creating a directoryPrerequisites
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.Syntax
drop_directory::=
Semantics
directory_name
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.
Example
Dropping a Directory: Example The following statement drops the directory object bfile_dir
:
DROP DIRECTORY bfile_dir;
See Also:
"Creating a Directory: Examples"