Purpose
This statement is used to delete a directory object.
Privilege requirements
To execute the DROP DIRECTORY statement, the current user must have the DROP ANY DIRECTORY privilege. For more information about the privileges in OceanBase Database, see Privilege classification in Oracle mode.
Syntax
DROP DIRECTORY directory_name;
Parameters
| Parameter | Description |
|---|---|
| directory_name | Specifies the directory object to be deleted. When a directory object is deleted, the associated shared file system path in the system will not be deleted. |
Examples
Delete a directory object named sql_file_dir.
obclient> DROP DIRECTORY sql_file_dir;
Query OK, 1 row affected