Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-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::=
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.
The following statement drops the stored outline called salaries
.
DROP OUTLINE salaries;
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|