DROP DIRECTORY v17
Name
DROP DIRECTORY — Remove a directory alias for a file system directory path.
Synopsis
DROP DIRECTORY <name>
Description
You must have the DROP ANY DIRECTORY system privilege to drop a directory. Here is an example of how an administrator could grant this privilege:
grant drop any directory to example_role;
DROP DIRECTORY drops an existing alias for a file system directory path that was created with the CREATE DIRECTORY command.
See UTL_FILE for more information on managing privileges for users.
When you delete a directory alias, the corresponding physical file system directory isn't affected. To delete the file system directory, use operating system commands.
Parameters
name
The name of a directory alias to remove.
Examples
Remove the directory alias empdir:
DROP DIRECTORY empdir;