|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 21 of 26
OUTLINE statement to drop a stored outline.
To drop an outline, you must have the
OUTLINE system privilege.
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