Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
CREATE TYPE to
DROP ROLLBACK SEGMENT, 12 of 26
Use the DROP
DIRECTORY
statement to remove a directory object from the database.
To drop a directory, you must have the DROP
ANY
DIRECTORY
system privilege.
drop_directory::=
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.
DROP
DIRECTORY
Example
The following statement drops the directory object bfile_dir
:
DROP DIRECTORY bfile_dir;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|