You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DDL


1 to 20 of 1529 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Concepts, 12c Release 1 (12.1)

Data Concurrency and Consistency

DDL LocksA data dictionary (DDL) lock protects the definition of a schema object while an ongoing DDL … are locked during DDL operations. The database never locks the whole data dictionary. Oracle … Database acquires a DDL lock automatically on behalf of any DDL transaction requiring it. Users cannot

Database Concepts, 12c Release 1 (12.1)

Oracle Database Instance

DDL LogThe DDL log has the same format and basic behavior as the alert log but contains only DDL … statements and details. The database writes DDL information to its own file to reduce the clutter in the … alert log. DDL log records are DDL text, optionally augmented with supplemental information. One log

Database SQL Language Reference, 12c Release 1 (12.1)

Automatic Locks in DDL Operations

Exclusive DDL LocksAn exclusive DDL lock prevents other session from obtaining a DDL or DML lock. Most DDL operations … require exclusive DDL locks to prevent destructive interference with other DDL operations that might … query against the table is not blocked. Exclusive DDL locks last for the duration

Database SQL Language Reference, 12c Release 1 (12.1)

Automatic Locks in DDL Operations

Share DDL LocksA share DDL lock for a resource prevents destructive interference with conflicting DDL operations … , but allows data concurrency for similar DDL operations. For example, when a CREATE PROCEDURE … statement is run, the containing transaction acquires share DDL locks for all referenced tables. Other … share DDL

Database Concepts, 12c Release 1 (12.1)

Glossary

DDLData definition language. Includes statements such as CREATE TABLE or ALTER INDEX that define or change a data structure.

Database SQL Language Reference, 12c Release 1 (12.1)

Common SQL DDL Clauses

8 Common SQL DDL ClausesThis chapter describes some SQL data definition clauses that appear in multiple SQL statements. This chapter contains these sections: allocate_extent_clause constraint deallocate_unused_clause file_specification logging_clause parallel_clause physical_attributes_clause size_clause storage_clause

Database Concepts, 12c Release 1 (12.1)

SQL

Data Definition Language (DDL) StatementsDDL enables you to alter attributes of an object without altering the applications that access the … rewriting the application. You can also use DDL to alter the structure of objects while database … users are performing work in the database. More specifically, DDL statements enable you to: Create … database users. Most

Database SQL Language Reference, 12c Release 1 (12.1)

Types of SQL Statements

Data Definition Language (DDL) StatementsData definition language (DDL) statements let you to perform these tasks: Create, alter, and drop … transaction before and after every DDL statement. A DDL statement is either blocking or nonblocking … , and both types of DDL statements require exclusive locks on internal structures. See Also: Oracle … Database

Database Administrator's Guide, 12c Release 1 (12.1)

Distributed Transactions Concepts

34.1.1 DML and DDL TransactionsSome DML and DDL operations are supported in a distributed transaction. The following are the DML … and DDL operations supported in a distributed transaction: CREATE TABLE AS SELECT DELETE INSERT … (default and direct load) UPDATE LOCK TABLE SELECT SELECT FOR UPDATE You can execute DML and DDL … operations after issuing parallel

Database SQL Language Reference, 12c Release 1 (12.1)

Automatic Locks in DDL Operations

Automatic Locks in DDL OperationsA data dictionary (DDL) lock protects the definition of a schema object while it is acted upon or … referred to by an ongoing DDL operation. For example, when a user creates a procedure, Oracle … Database automatically acquires DDL locks for all schema objects referenced in the procedure definition … . The DDL

Database SQL Language Reference, 12c Release 1 (12.1)

Automatic Locks in DDL Operations

Breakable Parse Locksnot disallow any DDL operation and can be broken to allow conflicting DDL operations. A parse lock is

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Shared Pool and the Large Pool

Avoid Performing DDL OperationsAvoid performing DDL operations on high-usage segments during peak hours. Performing DDL operations

Database Concepts, 12c Release 1 (12.1)

SQL

Differences Between DML and DDL ProcessingOracle Database processes DDL differently from DML. For example, when you create a table, the … database does not optimize the CREATE TABLE statement. Instead, Oracle Database parses the DDL statement … and carries out the command. In contrast to DDL, most DML statements have a query component. In a … about processing DDL,

Database Administrator's Guide, 12c Release 1 (12.1)

Administering a CDB with SQL*Plus

40.6 Executing DDL Statements in a CDBIn a CDB, you can execute a data definition language (DDL) statement in the current container or in all containers.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Schema Objects

18.7.2 Manually Recompiling Invalid Objects with DDLrecompile package body Pkg1, you would execute the following DDL statement: ALTER PACKAGE pkg1 COMPILE

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.6.7 Specifying the DDL Lock TimeoutYou can specify the amount of time that blocking DDL statements wait for locks. A data definition … language (DDL) statement is either nonblocking or blocking, and both types of DDL statements require … exclusive locks on internal structures. If these locks are unavailable when a DDL statement runs … , then nonblocking

Database SQL Tuning Guide, 12c Release 1 (12.1)

SQL Processing

How Oracle Database Processes DDLOracle Database processes DDL differently from DML. For example, when you create a table, the … database does not optimize the CREATE TABLE statement. Instead, Oracle Database parses the DDL statement … and carries out the command. The database processes DDL differently because it is a means of … SQL statements to execute a DDL

Database Administrator's Guide, 12c Release 1 (12.1)

Administering a CDB with SQL*Plus

40.6.1 About Executing DDL Statements in a CDBIn a CDB, some DDL statements can apply to all containers or to the current container only. To … PDBs. The following restrictions apply to the CONTAINER clause in DDL statements: The restrictions … described in \" About the Current Container \". You can use the CONTAINER clause only with the DDL … statements listed in Table 40-8.

Database Administrator's Guide, 12c Release 1 (12.1)

Administering a CDB with SQL*Plus

40.6.2 Executing a DDL Statement in the Current ContainerSpecify CURRENT in the CONTAINER clause of a DDL statement listed in to execute the statement in … the current container. The supported DDL statements are listed in Table 40-8. The current user must be … granted the required privileges to execute the DDL statement in the current container. For example … container. To execute a

Database Utilities, 12c Release 1 (12.1)

Character Set and Globalization Support Considerations

Data Definition Language (DDL)the dump file is imported, a character set conversion is required for DDL only if the import system's