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

Database Administrator's Guide, 11g Release 1 (11.1)

What Are Distributed Transactions?

DML and DDL TransactionsThe following are the DML and DDL operations supported in a distributed transaction: CREATE TABLE … DML and DDL statements in parallel, and INSERT direct load statements serially, but note the … cannot perform remote operations after issuing parallel DML/DDL or direct load INSERT. If the

Database SQL Language Reference, 11g Release 1 (11.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 Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

Specifying the DDL Lock TimeoutData Definition Language (DDL) statements require exclusive locks on internal structures. If these … locks are unavailable when a DDL statement runs, the DDL statement fails, though it might have … succeeded if it had been executed subseconds later. To enable DDL statements to wait for locks, specify a … DDL

Database SQL Language Reference, 11g Release 1 (11.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. 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 Administrator's Guide, 11g Release 1 (11.1)

Managing Object Dependencies

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

Database Data Warehousing Guide, 11g Release 1 (11.1)

Using Parallel Execution

Parallel DDLThis section includes the following topics on parallelism for DDL statements: DDL Statements That … Can Be Parallelized CREATE TABLE... AS SELECT in Parallel Recoverability and Parallel DDL Space … Management for Parallel DDL DDL Statements That Can Be Parallelized You can parallelize DDL

Database Concepts, 11g Release 1 (11.1)

Data Concurrency and Consistency

DDL LocksA data dictionary lock (DDL) protects the definition of a schema object while that object is acted … upon or referred to by an ongoing DDL operation. Recall that a DDL statement implicitly commits its … -statement transaction, Oracle Database automatically acquires DDL locks for all schema objects … referenced

Database Utilities, 11g Release 1 (11.1)

Original Export and Import

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

Database Concepts, 11g Release 1 (11.1)


DDLData definition language. Includes statements like CREATE/ALTER TABLE/INDEX, which define or change data structure.

Oracle C++ Call Interface Programmer's Guide, 11g Release 1 (11.1)

Introduction to OCCI

DDL StatementsDDL statements manage schema objects in the database. These statements create new tables, drop old … FROM jamie DDL statements also allow you to work with objects in the Oracle database, as in Example 1

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

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

Database Utilities, 11g Release 1 (11.1)

Using LogMiner to Analyze Redo Log Files

Tracking DDL Statements in the LogMiner Dictionarylanguage (DDL) statements. DDL tracking enables LogMiner to successfully track structural changes made … 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 dictionary … . Note:

Database Utilities, 11g Release 1 (11.1)

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 … Dictionary in the Redo Log Files for an example. To differentiate between DDL statements that were issued by

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Capture, Propagation, and Apply

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: \"Apply … information

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Executing DDL LCRsThe EXECUTE member procedure for DDL LCRs is a subprogram of the LCR$_DDL_RECORD type. When the … EXECUTE member procedure is run on a DDL LCR, the LCR is executed, and any apply process handlers that … would be run for the LCR are not run. The EXECUTE member procedure for DDL LCRs can be invoked only … in an apply handler for

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)


DDLrefers to data definition language, which includes statements defining or changing data structure.

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Understanding Oracle Streams Replication

Considerations for Applying DDL ChangesThe following sections discuss considerations for applying DDL changes to tables: System-Generated … Names CREATE TABLE AS SELECT Statements System-Generated Names If you plan to capture DDL changes at … a source database and apply these DDL changes at a destination database, then avoid using system … -generated names. If a DDL

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Monitoring Oracle Streams Replication

Displaying Information About DML and DDL HandlersThis section contains queries that display information about apply process DML handlers and DDL … handlers. See Also: Oracle Streams Concepts and Administration for more information about DML and DDL … APPLY_DATABASE_LINK column is NULL. See Also: \"Managing a DML Handler\" Displaying the DDL Handler … for Each Apply Process To

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Record Skip DDLScope Database Enterprise Manager name Record Skip DDL

Data Guard Concepts and Administration, 11g Release 1 (11.1)

Data Type and DDL Support on a Logical Standby Database

C.11.1 DDL Statements that Use DBLINKSSQL Apply may not correctly apply DDL statements such as the following, that reference a database … executing such a DDL statement, you should use the DBMS_LOGSTDBY.INSTANTIATE_TABLE procedure for the