Oracle7 Server SQL Reference

ALTER SNAPSHOT LOG

Purpose

Changes the storage characteristics of a snapshot log.

Prerequisites

Since a snapshot log is simply a table, the privileges that authorize operations on it are the same as those for a table. To change its storage characteristics, you must have the privileges listed for the ALTER TABLE command later in this chapter.

Syntax

Keywords and Parameters

schema

is the schema containing the snapshot log and its master table. If you omit schema, Oracle7 assumes the snapshot log is in your own schema.

table

is the name of the master table associated with the snapshot log to be altered.

PCTFREE PCTUSED INITRANS MAXTRANS

change the values of these parameters for the snapshot log. See the PCTFREE, PCTUSED, INITRANS, and MAXTRANS parameters of the CREATE TABLE command .

STORAGE

changes the storage characteristics of the snapshot log. See the STORAGE clause .

Usage Notes

For more information on snapshot logs, see the CREATE SNAPSHOT LOG command

Example

The following statement changes the MAXEXTENTS value of a snapshot log: