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 DML


1 to 40 of 60 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 … is actually a synonym for a local object.

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

Managing Views

DML Statements and Join ViewsThe general rule is that any UPDATE, DELETE, or INSERT statement on a join view can modify only one underlying base table. The following examples illustrate rules specific to UPDATE, DELETE, and INSERT statements.

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

Managing Synonyms

Using Synonyms in DML Statementsthe jward. employee synonym. A synonym can be referenced in a DML statement the same way that the

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

Loading Tables

Inserting Data with DML Error LoggingInserting Data wit h DML Error Logging When you load a table using an INSERT statement with … the DML error logging feature. To use DML error logging, you add a statement clause that specifies … the name of an error logging table into which the database records errors encountered during DML … continues. You then

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

Distributed Transaction Processing: Case Study

Stage 1: Client Application Issues DML StatementsAt the Sales department, a salesperson uses SQL*Plus to enter a sales order and then commit it. The application issues a number of SQL statements to enter the order into the sales database and update the inventory in the warehouse database: CONNECT scott@sales.acme.com...; INSERT INTO orders...; UPDATE inventory@warehouse.acme.com...; INSERT INTO orders...; UPDATE inventory@warehouse.acme.com...;

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

Managing Processes for Parallel SQL Execution

Enabling Parallel SQL ExecutionYou enable parallel SQL execution with an ALTER SESSION ENABLE PARALLEL DML|DDL|QUERY statement … . Subsequently, when a PARALLEL clause or parallel hint is associated with a statement, those DML, DDL … query statements. A DML statement can be parallelized only if you specifically issue an ALTER … SESSION statement to enable parallel

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

Managing Synonyms

Managing SynonymsSynonyms Creating Synonyms Using Synonyms in DML Statements Dropping Synonyms

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

Managing Processes for Parallel SQL Execution

Disabling Parallel SQL ExecutionYou disable parallel SQL execution with an ALTER SESSION DISABLE PARALLEL DML|DDL|QUERY statement … . All subsequent DML ( INSERT, UPDATE, DELETE ), DDL ( CREATE, ALTER ), or query ( SELECT ) operations

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

Loading Tables

Enabling Direct-Path INSERTinserting in parallel DML mode, direct-path INSERT is the default. In order to run in parallel DML mode … must enable parallel DML in your session. To do this, run the following statement: ALTER SESSION … { ENABLE | FORCE } PARALLEL DML; You must specify the parallel attribute for the target table, either at

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

Creating Indexes

Creating an Index Onlineyou are building or rebuilding indexes on that table. You can perform DML operations while the index … number of concurrently executing DML statements. Therefore, it is best to start online index builds … when DML activity is low. See Also: \"Rebuilding an Existing Index\"

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

Managing Processes for Parallel SQL Execution

Forcing Parallel SQL ExecutionYou can force parallel execution of all subsequent DML, DDL, or query statements for which … parallelization is possible with the ALTER SESSION FORCE PARALLEL DML|DDL|QUERY statement. Additionally you

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

Loading Tables

Error Logging Restrictions and Caveatsthe mandatory error description columns plus all of the columns from the named DML table, and … Restrictions and Caveats Oracle Database logs the following errors during DML operations: Column values … , and cause the DML operation to terminate and roll back. For a list of these errors and for other DML

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

Loading Tables

Error Logging Table Formatnames match the column names from the table being inserted into (the \"DML table\"). The number of … columns in the DML table. If a column exists in the error logging table that has the same name as a column … in the DML table, the corresponding data from the offending row being inserted is written to this … error logging table

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

About Oracle Database Resource Manager

Undo Poolgenerated by a consumer group exceeds its undo limit, the current DML statement generating the undo is

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

Managing Integrity Constraints

Set All Constraints Deferredbefore you actually begin processing any data. Use the following DML statement to set all deferrable

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

Loading Tables

Inserting Data Into Tables Using Direct-Path INSERTSpace Considerations Ensure that you consider space requirements before using DML error logging … table. Security The user who issues the INSERT statement with DML error logging must have INSERT … Database Data Warehousing Guide for DML error logging examples. Inserting Data Into Tables Using Direct

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

Redefining Tables Online

Performing Intermediate SynchronizationFINISH_REDEF_TABLE has been called, it is possible that a large number of DML statements have been executed on

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

Creating Location Transparency

Using Local Procedures to Call Remote Proceduresrequired DML. For example, assume that scott connects to local_db and creates the following

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

Altering Tables

Adding Table Columnsexclusive DML lock on the table. For some types of tables (for example, tables without LOB columns), if … operation and greatly reduce the amount of time that the table is locked for DML. You can add a

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

Managing Resumable Space Allocation

Using the DBMS_RESUMABLE Packagestatement. The parameter sessionID is the session ID in which the statement is executing. For parallel DML … /DDL, sessionID is any session ID which participates in the parallel DML/DDL. Oracle Database

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

Altering Tables

Moving a Table to a New Segment or Tablespacestatement does not permit DML against the table while the statement is executing. If you want to … leave the table available for DML while moving it, see \"Redefining Tables Online\". The following … UNUSABLE, and DML accessing the table using these indexes will receive an ORA-01502 error. The

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

Defining Database Services

Server-Side Usetuning. For parallel query and parallel DML, the query coordinator connects to a service just like

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

Data Access Failures Due to Locks

Transaction TimeoutsA DML statement that requires locks on a remote database can be blocked if another transaction own

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

Data Access Failures Due to Locks

Locks from In-Doubt TransactionsA query or DML statement that requires locks on a local database can be blocked indefinitely due to

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

Managing Resumable Space Allocation

What Operations are Resumable?() and OCIStmtFetch() are candidates. DML INSERT, UPDATE, and DELETE statements are candidates. The

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

What Are Distributed Transactions?

What Are Distributed Transactions?… There are two types of permissible operations in distributed transactions: DML and DDL Transactions Transaction Control Statements

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

Managing Integrity Constraints

Enable Novalidate Constraint Stateconstraint that is already enabled does not require any DML locks during validation (unlike validating

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

Monitoring Performance

Performance Monitoring Data Dictionary Viewsthe database and all outstanding requests for a DDL lock DBA_DML_LOCKS Lists all DML locks held in … the database and all outstanding requests for a DML lock DBA_LOCK Lists all locks or latches held in

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

Redefining Tables Online

Redefining Tables Onlinelogical or physical structure of a table to: Improve the performance of queries or DML Accommodate … both queries and DML during much of the redefinition process. The table is locked in the exclusive

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

Redefining Tables Online

Online Redefinition of a Single Partitionpartition to a different tablespace and keep the partition available for DML during the operation … available for DML when moving it to another tablespace, you can use the simpler ALTER TABLE MOVE PARTITION

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

Guidelines for Managing Tables

Consider Using Table Compressionloading and DML. Table compression is completely transparent to applications. It is especially … . When compression is enabled for all operations, compression occurs during all DML statements and when … DML, you must set the COMPATIBLE initialization parameter to 11.1.0 or higher. To enable compression

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

Analyzing Tables, Indexes, and Clusters

Validating Tables, Indexes, Clusters, and Materialized Viewsvalidation online while DML is occurring against the object being validated. There can be a slight … performance impact when validating with ongoing DML affecting the object, but this is offset by the

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

Enabling and Disabling Triggers

Enabling and Disabling Triggersexample, you can create a trigger to restrict DML operations against a table, allowing only statements … database. They are implicitly fired when: DML statements are executed ( INSERT, UPDATE, DELETE

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

Reclaiming Wasted Space

Understanding Reclaimable Unused Spacesegment remains available for queries and DML during most of the operation, and no extra disk space need

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

Redefining Tables Online

Features of Online Table Redefinitionfor DML when moving it to another tablespace, you can use the simpler ALTER TABLE MOVE command. See

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

Managing Index-Organized Tables

Maintaining Physical Guesses in Logical RowidsALTER INDEX... UPDATE BLOCK REFERENCES statement. This statement is performed online, while DML is

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

Scheduler Support for Oracle Data Guard

Scheduler Support for Oracle Data Guardrole. DML is replicated to the job event log so that on failover, a record of what had run

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

Deciding How to Handle In-Doubt Transactions

Look for Transaction Advicerecent DML statement executed at that database in the current transaction. For example, consider a

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

Creating Indexes

Creating an Invisible Indexindex is maintained during DML statements. To create an invisible index, use the SQL statement

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

Introduction to Automatic Undo Management

Retention Guaranteemultiple DML operations to fail. Use with caution. You enable retention guarantee by specifying the