|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
ALTER CLUSTER to ALTER SYSTEM, 10 of 19
OUTLINE statement to rename a stored outline, reassign it to a different category, or regenerate it by compiling the outline's SQL statement and replacing the old outline data with the outline created under current conditions.
To modify an outline, you must have the
OUTLINE system privilege.
Specify the name of the outline to be modified.
REBUILD to regenerate the execution plan for
outline using current conditions.
TO clause to specify an outline name to replace
TO clause to specify the name of the category into which the
outline will be moved.
The following statement regenerates a stored outline called
salaries by compiling the outline's text and replacing the old outline data with the outline created under current conditions.