My Oracle Support Banner

Primary Note: Overview of Oracle Data Definition Language (DDL) (Doc ID 1501399.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

Data definition language (DDL) statements define, structurally change, and drop schema objects.

The purpose of this Document is to provide an overview of Oracle Data Definition Language (DDL).

This is a LIVE document. Work is in progress to improve the quality of the content.

Scope

This document applies to a single instance environment.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Concepts
 Data Definition Language (DDL) Statements
 How Oracle Database Processes DDL
 Automatic Locks in DDL Operations
 Exclusive DDL Locks
 Share DDL Locks
 Breakable Parse Locks
 Specifying the DDL Lock Timeout (in 11.1 and higher)
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.