Add a column/integrity constraint to a table

ALTER TABLE

Add a comment to the data dictionary about a column

COMMENT

Add a comment to the data dictionary about a table or view

COMMENT

Add a comment to the data dictionary about a snapshot

COMMENT

Add or remove a resource limit to or from a profile

ALTER PROFILE

Add/drop/clear redo log file group members

ALTER DATABASE

Add/rename datafiles

ALTER TABLESPACE

Allocate an extent for a cluster

ALTER CLUSTER

Allocate an extent for the table

ALTER TABLE

Allow/disallow writing to a table

ALTER TABLE

Allow/disallow writing to a tablespace

ALTER TABLESPACE

Back up the current control file

ALTER DATABASE

Begin/end a backup

ALTER TABLESPACE

Bring a rollback segment online/offline

ALTER ROLLBACK SEGMENT

Change a rollback segment’s storage characteristics

ALTER ROLLBACK SEGMENT

Change a snapshot log’s storage characteristics

ALTER SNAPSHOT LOG

Change a user’s default role

ALTER USER

Change a user’s default tablespace

ALTER USER

Change a user’s password

ALTER USER

Change a user’s profile

ALTER USER

Change a user’s tablespace quotas

ALTER USER

Change a user’s temporary tablespace

ALTER USER

Change default storage characteristics

ALTER TABLESPACE

Change the authorization needed to access a role

ALTER ROLE

Change a snapshot’s storage, refresh time, or refresh mode

ALTER SNAPSHOT

Change the name of a database

CREATE CONTROL FILE

Change the name of a schema object

RENAME

Change the storage characteristics of a cluster

ALTER CLUSTER

Choose archivelog/noarchivelog mode

ALTER DATABASE

Choose auditing for specified SQL commands

AUDIT

Choose auditing for operations on schema objects

AUDIT

Collect performance statistics for a table, index, or cluster

ANALYZE

Convert an Oracle Version 6 data dictionary when migrating to Oracle7

ALTER DATABASE

Create a cluster that can contain one or more tables

CREATE CLUSTER

Create a database trigger

CREATE TRIGGER

Create a database

CREATE DATABASE

Create a directory database object (for BFILEs)

CREATE DIRECTORY

Create a library from which to call external 3GL functions and procedures

CREATE LIBRARY

Create a link to a remote database

CREATE DATABASE LINK

Create a new datafile

ALTER TABLESPACE

Create a new database user

CREATE USER

Create a new datafile in place of an old one for recovery purposes

ALTER DATABASE

Create a place in the database for storage of database objects

CREATE TABLESPACE

Create a profile and specify its resource limits

CREATE PROFILE

Create a role

CREATE ROLE

Create a rollback segment

CREATE ROLLBACK SEGMENT

Create a sequence for generating sequential values

CREATE SEQUENCE

Create a snapshot log containing changes made to the master table

CREATE SNAPSHOT LOG

Create a snapshot of data from one or more remote master tables

CREATE SNAPSHOT

Create a stored function

CREATE FUNCTION

Create a stored procedure

CREATE PROCEDURE

Create a synonym for a schema object

CREATE SYNONYM

Create a table and define its columns, constraints, and storage

CREATE TABLE

Create an incomplete object type

CREATE TYPE

Create an index for a table or cluster

CREATE INDEX

Create an object type

CREATE TYPE

Create the body of a stored package

CREATE PACKAGE BODY

Create the specification of a stored package

CREATE PACKAGE

Define a view of one or more tables or views

CREATE VIEW

Delete all the rows from a table

TRUNCATE TABLE or DELETE FROM

Delete a user from the database

DROP USER

Disable auditing by reversing the effect of a prior AUDIT statement

NOAUDIT

Enable/disable a database trigger

ALTER TRIGGER

Enable/disable a thread of redo log file groups

ALTER DATABASE

Enable/disable all triggers on a table

ALTER TABLE

Enable/disable autoextending the size of datafiles

ALTER TABLESPACE

Enable/disable table locks on a table

ALTER TABLE

Enable/disable/drop an integrity constraint

ALTER TABLE

Grant system privileges, roles, and object privileges to users and roles

GRANT

Identify chained rows for a table, index, or cluster

ANALYZE

Issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements

CREATE SCHEMA

Modify the degree of parallelism for a table

ALTER TABLE

Open/mount the database

ALTER DATABASE

Perform media recovery

ALTER DATABASE

Prepare to downgrade to an earlier release of Oracle

ALTER DATABASE

Recompile a stored function

ALTER FUNCTION

Recompile a stored package

ALTER PACKAGE

Recompile a stored procedure

ALTER PROCEDURE

Recompile a view

ALTER VIEW

Recreate a control file

CREATE CONTROLFILE

Recreate SQL commands to build the database to the trace file

ALTER DATABASE

Redefine a column to change a table’s storage characteristics

ALTER TABLE

Redefine an index’s future storage allocation

ALTER INDEX

Redefine value generation for a sequence

ALTER SEQUENCE

Remove a cluster from the database

DROP CLUSTER

Remove a database link

DROP DATABASE LINK

Remove a directory object from the database

DROP DIRECTORY

Remove a library object from the database

DROP LIBRARY

Remove a profile from the database

DROP PROFILE

Remove a role from the database

DROP ROLE

Remove a rollback segment from the database

DROP ROLLBACK SEGMENT

Remove a sequence from the database

DROP SEQUENCE

Remove a snapshot from the database

DROP SNAPSHOT

Remove a snapshot log from the database

DROP SNAPSHOT LOG

Remove a stored function from the database

DROP FUNCTION

Remove a stored package from the database

DROP PACKAGE

Remove a stored procedure from the database

DROP PROCEDURE

Remove a synonym from the database

DROP SYNONYM

Remove a table from the database

DROP TABLE

Remove a tablespace from the database

DROP TABLESPACE

Remove a trigger from the database

DROP TRIGGER

Remove a user and the objects in the user’s schema from the database

DROP USER

Remove a user-defined type from the database

DROP TYPE

Remove a view from the database

DROP VIEW

Remove all rows from a table or cluster and free the space that the rows used

TRUNCATE

Remove an index from the database

DROP INDEX

Rename a datafile/redo log file member

ALTER DATABASE

Resize one or more datafiles

ALTER DATABASE

Revoke system privileges, roles, and object privileges from users and roles

REVOKE

Shrink a rollback segment to an optimal or given size

ALTER ROLLBACK SEGMENT

Specify a formula to calculate the total cost of resources used by a session

ALTER RESOURCE COST

Take a datafile online/offline

ALTER DATABASE

Take a tablespace online/offline

ALTER TABLESPACE

Validate structure of a table, index, or cluster

ANALYZE