Oracle8i SQL Reference
Release 2 (8.1.6)

A76989-01

Library

Product

Contents

Index

Prev Up Next

SQL Statements (continued), 10 of 17


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;

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index