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
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
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
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
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
DDL → Data definition language. Includes statements such as CREATE TABLE or ALTER INDEX that define or change a data structure.
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
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
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
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
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
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,
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
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
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.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.
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
Data Definition Language (DDL) → the dump file is imported, a character set conversion is required for DDL only if the import system's