Oracle DBA SQL Quick Reference

Routines and syntax shared by multiple commands.

Allocate extent

Syntax of allocate extent statements.

Constraints

Syntax for setting constraints on an object.

Inline constraint

Out of line constraint

Inline ref constraint

Out of line ref constraint

References

Constraint state

Using index

Global partitioned index

Index partitioning

Segment attributes

Physical attributes

Exceptions

Deallocate Unused

Syntax for Deallocating Unused Space.

File Specification

Syntax for setting file specifications of database objects.

Datafile tempfile spec

Redo log file spec

Autoextend

Maxsize

Logging

Syntax for common logging specifications.

Parallel

Syntax for parallel options.

Physical Attributes

Syntax for common physical attributes of the database and its objects.

Storage

Syntax for setting storage parameters of the database.