ALTER OUTLINE

Purpose

Use the ALTER 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.

See Also: CREATE OUTLINE and Oracle8i Performance Guide and Reference for more information on outlines

Prerequisites

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

Syntax

Keywords and Parameters

outline

Specify the name of the outline to be modified.

REBUILD

Specify REBUILD to regenerate the execution plan for outline using current conditions.

RENAME TO new_outline_name

Use the RENAME TO clause to specify an outline name to replace outline.

CHANGE CATEGORY TO new_category_name

Use the CHANGE CATEGORY TO clause to specify the name of the category into which the outline will be moved.

Example

ALTER OUTLINE 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;