ALTER OUTLINE

Syntax

Purpose

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.

See Also: "CREATE OUTLINE" and Oracle8i Designing and Tuning for Performance for more information on outlines.

Prerequisites

To modify an outline, you must have the ALTER ANY OUTLINE system privilege.

Keywords and Parameters

outline	is the name of the outline to be modified.
REBUILD	regenerates the execution plan for outline using current conditions.
RENAME TO new_outline_name	specifies an outline name to replace outline.
CHANGE CATEGORY TO new_category_name	specifies the name of the category into which the outline will be moved.

Example

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.

ALTER OUTLINE salaries REBUILD;