Alter

Alter statements modify the object referenced. The object must already exist.

Alter Cluster

Change storage for an existing cluster.

Alter Database

Alter the status, control files, redo logs, etc., of the database.

Startup

Recovery

General recovery

Full database recovery

Partial database recovery

Parallel

Managed standby recovery

Recover

Cancel

Finish

Database file

Autoextend

Maxsize

logfile

logfile descriptor

Controlfile

Trace file

Standby database

Commit switchover

Default settings

Set time_zone

Conversion

Redo thread

Security

Alter Dimension

Modify the attributes or hierarchical relationships of a dimension.

Level

Hierarchy

Join

Attribute

Alter Function

Recompile the function.

Alter Index

Modify storage for an existing index.

Rebuild

Key compression

Alter index partitioning

Modify index default attributes

Modify index partition

Rename index partition

Drop index partition

Split index partition

Index partition description

Segment attributes

Modify index subpartition

Alter Indextype

Modify the properties of the Indextype and add or drop operators.

Using type

Alter Java

Force resolution of class schema objects and compilation of Java source schema objects.

Invoker rights

Alter Materialized View

Modify an existing Materialized View.

Data segment compression

LOB storage

LOB parameters

Modify LOB storage

Modify LOB parameters

Alter IOT

Index organized table

Index organized overflow

Alter overflow

Add overflow

Scoped table ref constraint

Alter materialized view refresh

Alter Materialized View Log

Modify the characteristics of a Materialized View Log.

New values

Alter Operator

Compile an existing operator.

Alter Outline

Modify an existing outline statement.

Alter Package

Recompile a package as a unit.

Alter Procedure

Recompile a standalone stored procedure.

Alter Profile

Modify a profile to change resource limits or password management in an existing profile.

Resource parameters

Password parameters

Alter Resource Cost

Specify or modify the resource cost for a particular session.

Alter Role

Modify the authorization parameters for a role.

Alter Rollback Segment

Modify the status and storage parameters of a rollback segment.

Alter Sequence

Modify the parameters of a sequence.

Alter Session

Modify the parameters of the current session.

Alter System

Modify the parameters of the current instance, dynamically.

Archive log

End session

Alter system set

Alter system set

Alter Table

Alter the definition of a table, partitioned table, or table subpartition.

Alter table properties

Data segment compression

Supplemental log group

Upgrade table

Records per block

Row movement

Alter IOT

Index organized table

Mapping table

Key compression

Index organized overflow

Segment attributes

Alter overflow

Add overflow

Alter mapping table

Column

Add column

Modify column

Modify column properties

Drop column

Rename column

Modify collection retrieval

Constraint

Drop constraint

Column properties

Object type column properties

Substitutable column

Nested table column properties

Object properties

Supplemental logging properties

Physical properties

Varray column properties

LOB storage

LOB parameters

Modify LOB storage1

Modify LOB parameters

Alter varray column properties

LOB partition storage

XMLType column properties

XMLType storage

XMLSchema spec

Alter external table

External data properties

Alter table partitioning

Modify table default attributes

Set subpartition template

Modify table partition

Modify range partition

Modify hash partition

Modify list partition

Modify table subpartition

Move table partition

Move table subpartition

Add table partition

Add range partition

Add hash partition

Add list partition

Coalesce table partition

Drop table partition

Drop table subpartition

Rename partition subpartition

Truncate partition subpartition

Split table partition

Split table subpartition

Merge table partitions

Merge table subpartitions

Exchange partition subpartition

List values

Range values

Partitioning storage

Partition attributes

Add hash subpartition

Add list subpartition

Modify hash subpartition

Modify list subpartition

Table partition description

Partition level subpartition

Partition spec

Subpartition spec

Update global index

Parallel

Move table

Enable disable

Using index

Global partitioned index

Index partitioning

Alter Tablespace

Alter the status and parameters of a tablespace.

Datafile tempfile

Alter Trigger

Enable, disable, or compile a trigger.

Alter Type

Modify the properties of a Type.

Invoker rights

Element spec

Inheritance

Subprogram

Procedure spec

Function spec

Constructor spec

Map order function spec

Pragma

Alter method spec

Alter attribute definition

Dependent handling

Exceptions

Alter User

Modify the authentication parameters and storage parameters of a user.

Proxy

Alter View

Modify the constraints or explicitly recompile a view