Oracle DBA SQL Quick Reference
| 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 |