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 1505 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

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 Administrator's Guide, 11g Release 2 (11.2)

Distributed Transactions Concepts

DML and DDL Transactionspermissible operations in distributed transactions: DML and DDL Transactions Transaction Control Statements … DML and DDL Transactions The following are the DML and DDL operations supported in a distributed … SELECT FOR UPDATE You can execute DML and DDL statements in parallel, and INSERT direct load … serial

Database SQL Language Reference, 11g Release 2 (11.2)

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 Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Specifying the DDL Lock TimeoutA data definition language (DDL) statement is either nonblocking or blocking, and both types of DDLDDL statement runs, then nonblocking and blocking DDL statements behave differently: Nonblocking DDL … waits until every concurrent DML transaction that references the object affected by the DDL

Database SQL Language Reference, 11g Release 2 (11.2)

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. Many DDL statements may cause Oracle Database to … reauthorizes schema objects and the circumstances under which a DDL statement would cause this, see Oracle … Database

Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

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 Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

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

Database Concepts, 11g Release 2 (11.2)

Data Concurrency and Consistency

DDL LocksIndexes\" DDL Locks A data dictionary (DDL) lock protects the definition of a schema object while an … ongoing DDL operation acts on or refers to the object. Only individual schema objects that are … modified or referenced are locked during DDL operations. The database never locks the whole data … dictionary.

Database Utilities, 11g Release 2 (11.2)

Original Import

Data Definition Language (DDL)Up to three character set conversions may be required for data definition language (DDL) during an

Database Utilities, 11g Release 2 (11.2)

Original Export

Data Definition Language (DDL)Up to three character set conversions may be required for data definition language (DDL) during an

Database Concepts, 11g Release 2 (11.2)

Glossary

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

Database Concepts, 11g Release 2 (11.2)

SQL

Data Definition Language (DDL) StatementsData definition language ( DDL ) statements define, structurally change, and drop schema objects … . For example, DDL statements enable you to: Create, alter, and drop schema objects and other database … structures, including the database itself and database users. Most DDL statements start with the … data dictionary ( COMMENT

Database Concepts, 11g Release 2 (11.2)

SQL

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 process DDL differently because it is a means of defining … SQL statements to execute

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

Datatypes and Host Variables

Embedded DDLdata definition language (DDL) statements. This restriction cannot be enforced when precompiling, so … the use of extended column types, such as NCHAR, within embedded DDL statements results in an

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

Using Oracle Application Express Utilities

Generating DDL, specific object types, or specific objects. To generate a DDL statement: On the Workspace home page, click … the Utilities icon. Click Generate DDL. The Generate DDL page appears. Click Create Script. The … Generate DDL Wizard appears. Select a database schema and click Next. Define the object type: Output

Database Utilities, 11g Release 2 (11.2)

Using LogMiner to Analyze Redo Log Files

Reapplying DDL Statements Returned to V$LOGMNR_CONTENTSBe aware that some DDL statements issued by a user cause Oracle to internally execute one or more … other DDL statements. If you want to reapply SQL DDL from the SQL_REDO or SQL_UNDO columns of the V … LogMiner Dictionary in the Redo Log Files\" for an example. To differentiate between DDL statements that … $LOGMNR_CONTENTS.

Database Utilities, 11g Release 2 (11.2)

Using LogMiner to Analyze Redo Log Files

Tracking DDL Statements in the LogMiner Dictionarydefinition language (DDL) statements. DDL tracking enables LogMiner to successfully track structural changes … ); See \"Example 5: Tracking DDL Statements in the Internal Dictionary\" for a complete example. With … this option set, LogMiner applies any DDL statements seen in the redo log files to its internal

Streams Concepts and Administration, 11g Release 2 (11.2)

Managing Oracle Streams Information Consumption

Managing a DDL HandlerThis section contains instructions for creating, specifying, and removing the DDL handler for an … apply process. Note: All applied DDL LCRs commit automatically. Therefore, if a DDL handler calls the … EXECUTE member procedure of a DDL LCR, then a commit is performed automatically. See Also: \"Message