Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
CREATE TYPE to
DROP ROLLBACK SEGMENT, 21 of 26
Use the DROP
OUTLINE
statement to drop a stored outline.
See Also:
|
To drop an outline, you must have the DROP
ANY
OUTLINE
system privilege.
drop_outline::=
drop_outline
Specify the name of the outline to be dropped.
After the outline is dropped, if the SQL statement for which the stored outline was created is compiled, the optimizer generates a new execution plan without the influence of the outline.
DROP
OUTLINE
Example
The following statement drops the stored outline called salaries
.
DROP OUTLINE salaries;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|