How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Share DDL Locks → A 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
Exclusive DDL Locks → An 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
8 Common SQL DDL Clauses → This 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
34.1.1 DML and DDL Transactions → Some 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
Automatic Locks in DDL Operations → A 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
Data Definition Language (DDL) Statements → Data 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
Breakable Parse Locks → not disallow any DDL operation and can be broken to allow conflicting DDL operations. A parse lock is
Avoid Performing DDL Operations → Avoid performing DDL operations on high-usage segments during peak hours. Performing DDL operations
2.6.7 Specifying the DDL Lock Timeout → You 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
40.6 Executing DDL Statements in a CDB → In a CDB, you can execute a data definition language (DDL) statement in the current container or in all containers.
18.7.2 Manually Recompiling Invalid Objects with DDL → recompile package body Pkg1, you would execute the following DDL statement: ALTER PACKAGE pkg1 COMPILE
DDL Log → The 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
DDL Locks → A 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
How Oracle Database Processes DDL → Oracle 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
40.6.2 Executing a DDL Statement in the Current Container → Specify 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
40.6.1 About Executing DDL Statements in a CDB → In 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.
Data Definition Language (DDL) → the dump file is imported, a character set conversion is required for DDL only if the import system's
15.3.2 Committed DDL Statements → For 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
Data Definition Language (DDL) → Up to three character set conversions may be required for data definition language (DDL) during an
Data Definition Language (DDL) → Up to three character set conversions may be required for data definition language (DDL) during an
DDL → Data definition language. Includes statements such as CREATE TABLE or ALTER INDEX that define or change a data structure.
40.6.3 Executing a DDL Statement in All Containers in a CDB → Specify 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
Data Definition Language (DDL) Statements → … DDL 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
Embedded DDL → data 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
6.7 Nonblocking and Blocking DDL Statements → The 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
Tracking DDL Statements in the LogMiner Dictionary → definition 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
Differences Between DML and DDL Processing → Oracle 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,
Reapplying DDL Statements Returned to V$LOGMNR_CONTENTS → Be 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.
Executing DDL LCRs → The 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
DDL in DBMS_DATA_MINING → Table 2-3 describes the DDL operations for mining models. Table 2-3 DDL for Mining Models DDL
Managing a DDL Handler → This 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
16.9.6 DDL Statements on Tables Enabled for Flashback Data Archive → Flashback 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
Table 94-23 SET_TRANSFORM_PARAM: Transform Parameters for the DDL Transform → terminator (. 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
Example 5: Tracking DDL Statements in the Internal Dictionary → dictionary 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
DDL → Data definition language. Statements that define or change a data structure.
DDL → refers to data definition language, which includes statements defining or changing data structure.
Considerations for Applying DDL Changes → The following sections discuss considerations for applying DDL changes to tables: System-Generated … Names CREATE TABLE AS SELECT Statements DML Statements within DDL Statements
DML Statements within DDL Statements → When 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
Example 1 Skipping all DML and DDL changes made to a schema → The following example shows how to specify rules so that SQL Apply will skip both DDL and DML
11.7.5 How EDS-Based Replication Handles DDL → definition, 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
Executing SQL DDL and DML Statements → Executing S QL DDL and DML Statements SQL is the industry-wide language for working with relational
Decide Whether to Maintain DDL Changes → must 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,
C.13.1 DDL Statements that Use DBLINKS → SQL 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.
data dictionary (DDL) lock → A 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.
5.74 DDL Panel for Creating or Editing an Object → You 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.
C.13 DDL Statements Supported by a Logical Standby Database → information 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
Creating a DDL Handler for an Apply Process → A 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
Types of DDL Changes Ignored by an Apply Process → The following types of DDL changes are not supported by an apply process. These types of DDL … DDL 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
2.2.7 Generating the DDL for the Oracle Schema Objects → To 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
Table 2-3 Attributes Present in All DDL LCRs → occurred. 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
Setting the DDL Handler for an Apply Process → A 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
Removing the DDL Handler for an Apply Process → A 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
Displaying the DDL Handler for Each Apply Process → To 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\"
Table 2-4 Additional Attributes in Captured DDL LCRs → row 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
11.5.3 Setting up a Skip Handler for a DDL Statement → You 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
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
C Data Type and DDL Support on a Logical Standby Database → Unsupported Tables Skipped SQL Statements on a Logical Standby Database DDL Statements Supported by a Logical
C.4 Support for Tablespace Encryption → Oracle 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
C.5.2 Fine-Grained Auditing → Fine-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
C.10 PL/SQL Supplied Packages Considerations → This 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