|Oracle® Database SQL Reference
10g Release 1 (10.1)
Part Number B10759-01
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, then the optimizer generates a new execution plan without the influence of the outline.
The following statement drops the stored outline called
DROP OUTLINE salaries;