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


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 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)

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, 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)

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 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 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 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 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 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 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.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 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 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

Database Development Guide, 12c Release 1 (12.1)

Using Continuous Query Notification (CQN)

15.3.2 Committed DDL StatementsFor both OCN and QRCN, these data definition language (DDL) statements, when committed, generate … of DDL operation Some DDL operations that invalidate registered queries can cause those queries to … ) This DDL statement, when committed, invalidates the query and causes it to be removed from the registration: ALTER TABLE

Database Utilities, 12c Release 1 (12.1)

Data Definition Language (DDL)

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

Database Utilities, 12c Release 1 (12.1)

Data Definition Language (DDL)

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

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 Administrator's Guide, 12c Release 1 (12.1)

Administering a CDB with SQL*Plus

40.6.3 Executing a DDL Statement in All Containers in a CDBSpecify ALL in the CONTAINER clause of a DDL statement to execute the statement in all of the … containers in a CDB. The supported DDL statements are listed in Table 40-8. The following prerequisites … privileges commonly to execute the DDL statement. For example, to create a user, the current user must … be granted the CREATE

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

Pro*COBOL Programmer's Guide, 12c Release 1 (12.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 Development Guide, 12c Release 1 (12.1)

SQL Processing for Application Developers

6.7 Nonblocking and Blocking DDL StatementsThe distinction between nonblocking and blocking DDL statements matters only for DDL statements … that change either tables or indexes (which depend on tables). When a session issues a DDL statement … statements. If the DDL statement is nonblocking, then the new DML statements execute immediately. If the … DDL

Database Utilities, 12c Release 1 (12.1)

Tracking DDL Statements in the LogMiner Dictionary

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

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 Utilities, 12c Release 1 (12.1)

Reapplying DDL Statements Returned to V$LOGMNR_CONTENTS

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 … V$LOGMNR_CONTENTS.

Streams Replication Administrator's Guide, 12c Release 1 (12.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 Mining User's Guide, 12c Release 1 (12.1)

DDL in DBMS_DATA_MINING

DDL in DBMS_DATA_MININGTable 2-3 describes the DDL operations for mining models. Table 2-3 DDL for Mining Models DDL

Streams Concepts and Administration, 12c Release 1 (12.1)

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

Database Development Guide, 12c Release 1 (12.1)

Using Oracle Flashback Technology

16.9.6 DDL Statements on Tables Enabled for Flashback Data ArchiveFlashback Data Archive supports only these DDL statements: ALTER TABLE statement that does any of … renames a table Flashback Data Archive does not support DDL statements that move, split, merge, or … , the following DDL statements cause error ORA-55610 when used on a table enabled for Flashback Data … TABLE statement If you must

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_METADATA

Table 94-23 SET_TRANSFORM_PARAM: Transform Parameters for the DDL Transformterminator (. or / ) to each DDL statement. Defaults to FALSE. TABLE CONSTRAINTS BOOLEAN If TRUE … , include all non-referential table constraints in the DDL. If FALSE, omit them. Defaults to TRUE. TABLE … REF_CONSTRAINTS BOOLEAN If TRUE, include all referential constraints (foreign keys) in the DDL. If … . TABLE, TYPE OID BOOLEAN

Database Utilities, 12c Release 1 (12.1)

Example 5: Tracking DDL Statements in the Internal Dictionary

Example 5: Tracking DDL Statements in the Internal Dictionarydictionary is updated with the DDL statements encountered in the redo log files. Determine which … successfully apply DDL statements encountered in the redo log files, ensure that all files are

XML Developer's Kit Programmer's Guide, 12c Release 1 (12.1)

Glossary

DDLData definition language. Statements that define or change a data structure.

Data Provider for .NET Developer's Guide, 12c Release 1 (12.1)

Glossary

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

Streams Concepts and Administration, 12c Release 1 (12.1)

Advanced Apply Process Concepts

Considerations for Applying DDL ChangesThe following sections discuss considerations for applying DDL changes to tables: System-Generated … Names CREATE TABLE AS SELECT Statements DML Statements within DDL Statements

Streams Concepts and Administration, 12c Release 1 (12.1)

Advanced Apply Process Concepts

DML Statements within DDL StatementsWhen an apply process applies a data definition language (DDL) change, Oracle Streams ensures that … the data manipulation language (DML) changes on the DDL target within the same transaction are not … cause the source database and destination database to diverge: The DDL Statement Contains Derived … Values The DDL

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_LOGSTDBY

Example 1   Skipping all DML and DDL changes made to a schemaThe following example shows how to specify rules so that SQL Apply will skip both DDL and DML

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Managing a Logical Standby Database

11.7.5 How EDS-Based Replication Handles DDLdefinition, it is possible that DDL operations might alter the table in such a way that the triggers are no … new definition. To enable (or disable) automatic DDL handling, you must use the … DBMS_LOGSTDBY.EDS_EVOLVE_AUTOMATIC procedure. When automatic DDL handling is enabled, an EDS-specific DDL trigger fires

Oracle C++ Call Interface Programmer's Guide, 12c Release 1 (12.1)

Accessing Oracle Database Using C++

Executing SQL DDL and DML StatementsExecuting S QL DDL and DML Statements SQL is the industry-wide language for working with relational

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

Preparing for Oracle Streams Replication

Decide Whether to Maintain DDL Changesmust decide whether you want the replication environment to maintain data definition language (DDL … ) changes as well. Examples of statements that result in DDL changes are CREATE TABLE, ALTER TABLE, ALTER … database objects are the same at each database. In this case, maintaining DDL changes with Oracle Streams … databases,

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Data Type and DDL Support on a Logical Standby Database

C.13.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, then use the DBMS_LOGSTDBY.INSTANTIATE_TABLE procedure for the table being created, and then restart SQL APPLY operations.

Database Concepts, 12c Release 1 (12.1)

Glossary

data dictionary (DDL) lockA lock that protects the definition of a schema object while an ongoing DDL operation acts on or … refers to the object. Oracle Database acquires a DDL lock automatically on behalf of any DDL … transaction requiring it. Users cannot explicitly request DDL locks.

SQL Developer User's Guide, 12c Release 1 (12.1)

SQL Developer Dialog Boxes and Wizards

5.74 DDL Panel for Creating or Editing an ObjectYou can review and save the SQL statement that SQL Developer will use to create or edit the object, to reflect any changes you have made to the object's properties. If you want to make any changes, go back to the relevant panels and make the changes there. To save the SQL statement to a script file, click Save and specify the location and file name.

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Data Type and DDL Support on a Logical Standby Database

C.13 DDL Statements Supported by a Logical Standby Databaseinformation about the DBMS_LOGSTDBY package and Setting up a Skip Handler for a DDL Statement Table C … ) INDEX ALTER INDEX CREATE INDEX DROP INDEX NON_SCHEMA_DDL All DDL that does not pertain to a

Streams Concepts and Administration, 12c Release 1 (12.1)

Managing Oracle Streams Information Consumption

Creating a DDL Handler for an Apply ProcessA DDL handler must have the following signature: PROCEDURE handler_procedure ( parameter_name IN … ANYDATA encapsulation of a DDL LCR. A DDL handler can be used for any customized processing of DDL LCRs … for the LCR. When you execute a DDL LCR in a DDL handler, the apply process applies

Streams Concepts and Administration, 12c Release 1 (12.1)

Oracle Streams Restrictions

Types of DDL Changes Ignored by an Apply ProcessThe following types of DDL changes are not supported by an apply process. These types of DDLDDL LCR that specifies an operation that cannot be applied, then the apply process ignores the DDL … LCR and records the following message in the apply process trace file, followed by the DDL text that

SQL Developer User's Guide, 12c Release 1 (12.1)

SQL Developer: Migrating Third-Party Databases

2.2.7 Generating the DDL for the Oracle Schema ObjectsTo generate the DDL statements to create the Oracle schema objects, you must already have captured … the captured model and created the converted model. After you generate the DDL, you can run the DDL … schema is migrated to Oracle. After you generate and run the DDL statements to migrate the schema

Streams Concepts and Administration, 12c Release 1 (12.1)

Oracle Streams Information Capture

Table 2-3 Attributes Present in All DDL LCRsoccurred. command_type The type of DDL statement that produced the change, for example ALTER TABLE or … CREATE INDEX. object_owner The schema name of the user who owns the database object on which the DDL … statement was run. object_name The name of the database object on which the DDL statement was run … . object_type The type

Streams Concepts and Administration, 12c Release 1 (12.1)

Managing Oracle Streams Information Consumption

Setting the DDL Handler for an Apply ProcessA DDL handler processes all DDL LCRs dequeued by an apply process. Set the DDL handler for an apply … . For example, the following procedure sets the DDL handler for an apply process named strep01_apply

Streams Concepts and Administration, 12c Release 1 (12.1)

Managing Oracle Streams Information Consumption

Removing the DDL Handler for an Apply ProcessA DDL handler processes all DDL LCRs dequeued by an apply process. You remove the DDL handler for … the DBMS_APPLY_ADM package. For example, the following procedure removes the DDL handler from an

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Oracle Streams Apply Processes

Displaying the DDL Handler for Each Apply ProcessTo display the DDL handler for each apply process in a database, run the following query: COLUMN … APPLY_NAME HEADING 'Apply Process Name' FORMAT A20 COLUMN DDL_HANDLER HEADING 'DDL Handler' FORMAT A40 … Process Name DDL Handler -------------------- ---------------------------------------- STREP01_APPLY … \"STRMADMIN\".\"HISTORY_DDL\"

Streams Concepts and Administration, 12c Release 1 (12.1)

Oracle Streams Information Capture

Table 2-4 Additional Attributes in Captured DDL LCRsrow LCRs and DDL LCRs contain the source database name of the database where a change originated. If … for a complete list of the types of DDL statements in the \"SQL Command Codes\" table Oracle Database … discussed in the previous sections, row LCRs and DDL LCRs optionally can include the extra information (or LCR attributes) described

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Managing a Logical Standby Database

11.5.3 Setting up a Skip Handler for a DDL StatementYou can create a procedure to intercept certain DDL statements and replace the original DDL … transparently handle DDL transactions with file specifications. The following procedure can handle … handle tablespace DDL transactions: CREATE OR REPLACE PROCEDURE SYS.HANDLE_TBS_DDL ( OLD_STMT IN

Database Concepts, 12c Release 1 (12.1)

Concepts for Database Administrators

Automatic Diagnostic Repository ADR is a file-based repository that stores database diagnostic data…Oracle LogMiner Oracle LogMiner enables you to query redo log files through a SQL interface. Potential uses for data contained in redo log files include: Pinpointing when a logical corruption to a database, such as errors made at the application level, may have begun Detecting user error Determining what actions you would have to take to perform fine-grained recovery at the transaction level Using

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Data Type and DDL Support on a Logical Standby Database

C Data Type and DDL Support on a Logical Standby DatabaseUnsupported Tables Skipped SQL Statements on a Logical Standby Database DDL Statements Supported by a Logical

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Data Type and DDL Support on a Logical Standby Database

C.4 Support for Tablespace EncryptionOracle Data Guard SQL Apply can be used to provide data protection for a primary database that has tablespace encryption enabled. In such a case, restrictions 1, 2, and 3 listed in Support for Transparent Data Encryption (TDE) will apply. Note: In some cases, when SQL Apply mines and applies redo records for changes made to tables in encrypted tablespaces, records of user data in unencrypted form

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Data Type and DDL Support on a Logical Standby Database

C.5.2 Fine-Grained AuditingFine-grained auditing provides a way to audit select statements. The DBMS_FGA package enables all select statements that access a table to be captured, together with what data was accessed. An FGA policy may be applied to a particular column or even to only those select statements that return rows for which a specified predicate returns TRUE. When a DBMS_FGA procedure is executed on the primary, additional

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Data Type and DDL Support on a Logical Standby Database

C.10 PL/SQL Supplied Packages ConsiderationsThis section discusses the following considerations regarding PL/SQL supplied packages: Supported PL/SQL Supplied Packages Unsupported PL/SQL Supplied Packages Handling XML and XDB PL/SQL Packages in Logical Standby See Also: Oracle Database PL/SQL Packages and Types Reference for more information about Oracle PL/SQL supplied packages