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 ROLLBACK


1 to 20 of 846 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

ROLLBACK

ROLLBACKPurpose Use the ROLLBACK statement to undo work done in the current transaction or to manually undo … end transactions in application programs using either a COMMIT or ROLLBACK statement. If you do not … . Syntax rollback::= Description of the illustration rollback.gif Semantics WORK The keyword WORK is … which you want to roll

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Conne ction Class

rollback()Drops all changes made since the previous commit or rollback, and releases any database locks currently held by the session. Syntax void rollback();

2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

Rollback SegmentsIn earlier releases of the Oracle database, rollback segments were database structures used to … Rollback Segments. You see the attributes of the system rollback segment. The system rollback segment is self managing.

User's Guide and Reference, 10g Release 1 (10.1)

ROLLBACK Statement

ROLLBACK StatementThe ROLLBACK statement is the inverse of the COMMIT statement. It undoes some or all database … Description ROLLBACK When a parameterless ROLLBACK statement is executed, all database changes made … during the current transaction are undone. ROLLBACK TO Undoes all database changes (and releases all … rollback

Packages and Types Reference, 10g Release 1 (10.1)

101 DBMS_TRANSACTION

ROLLBACK ProcedureThis procedure is equivalent to the SQL statement: ROLLBACK This procedure is included for

SQL Reference, 10g Release 1 (10.1)

DROP ROLLBACK SEGMENT

DROP ROLLBACK SEGMENTPurpose Use the DROP ROLLBACK SEGMENT to remove a rollback segment from the database. When you drop … a rollback segment, all space allocated to the rollback segment returns to the tablespace. Note: If … rollback segments. In that mode, you cannot create or alter a rollback segment.

SQL Reference, 10g Release 1 (10.1)

DROP ROLLBACK SEGMENT

Restrictions on Dropping Rollback SegmentsYou can drop a rollback segment only if it is offline. To determine whether a rollback segment is … offline, query the data dictionary view DBA_ROLLBACK_SEGS. Offline rollback segments have the value … AVAILABLE in the STATUS column. You can take a rollback segment offline with the OFFLINE clause of … the ALTER

SQL Reference, 10g Release 1 (10.1)

CREATE ROLLBACK SEGMENT

CREATE ROLLBACK SEGMENTusing rollback segments. Please refer to Oracle Database Administrator's Guide for information on … automatic undo management. Purpose Use the CREATE ROLLBACK SEGMENT statement to create a rollback segment … parameter is set to AUTO ), then user-created rollback segments are irrelevant. Further, if your … database

SQL Reference, 10g Release 1 (10.1)

ALTER ROLLBACK SEGMENT

ALTER ROLLBACK SEGMENTusing rollback segments. Please refer to Oracle Database Administrator's Guide for information on … automatic undo management. Use the ALTER ROLLBACK SEGMENT statement to bring a rollback segment online or … information in this section assumes that your database is running in rollback undo mode (the … user-created

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

17 Internet Access to Oracle Streams AQ

IDAP Rollback ResponseThe response to a rollback request uses the AQXmlRollbackResponse method, which consists of

Concepts, 10g Release 1 (10.1)

4 Transaction Management

Statement-Level Rollbackrolled back. The effect of the rollback is as if that statement had never been run. This operation is … a statement-level rollback. Errors discovered during SQL statement execution cause statement-level … statement-level rollback. Errors discovered during SQL statement parsing, such as a syntax error, have not … yet been run,

Concepts, 10g Release 1 (10.1)

4 Transaction Management

Rollback of Transactionsuncommitted transaction. Oracle uses undo tablespaces (or rollback segments) to store old values … called a savepoint. All types of rollbacks use the same procedures: Statement-level rollback (due to … statement or deadlock execution error) Rollback to a savepoint Rollback of a transaction due to user … request

Release 1.8, 10g Release 1 (10.1)

Defining and Controlling Transactions

Using the ROLLBACK StatementROLLBACK Statement You use the ROLLBACK statement to undo pending changes made to the database. For example … , if you make a mistake, such as deleting the wrong row from a table, you can use ROLLBACK to … restore the original data. The ROLLBACK statement has no effect on the values of host variables or on the

Programmer's Guide, 10g Release 1 (10.1)

2 OCI Programming Basics

Commit or RollbackAn application commits changes to the database by calling OCITransCommit(). This call uses a service context as one of its parameters. The transaction is associated with the service context whose changes are committed. This transaction can be explicitly created by the application or implicitly created when the application modifies the database. Note: Using the OCI_COMMIT_ON_SUCCESS mode of the OCIExecute()

Release 1.8, 10g Release 1 (10.1)

Embedded SQL Commands and Directives

ROLLBACK (Executable Embedded SQL)Purpose To undo work done in the current transaction.

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

3 Database Concepts

3.8 The ROLLBACK StatementYou use the ROLLBACK statement to undo pending changes made to the database. For example, if you … make a mistake, such as deleting the wrong row from a table, you can use ROLLBACK to restore the … complete (a SQL statement might not execute successfully, for example), ROLLBACK lets you return to the … ROLLBACK

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

3 Database Concepts

3.7 Using the ROLLBACK StatementYou use the ROLLBACK statement to undo pending changes made to the database. For example, if you … make a mistake, such as deleting the wrong row from a table, you can use ROLLBACK to restore the … original data. The ROLLBACK statement has no effect on the values of host variables or on the flow of … control in your program. Specifically,

SQL Reference, 10g Release 1 (10.1)

18 SQL Statements: DROP SEQUENCE to ROLLBACK

18 SQL Statements: DROP SEQUENCE to ROLLBACKFLASHBACK TABLE GRANT INSERT LOCK TABLE MERGE NOAUDIT PURGE RENAME REVOKE ROLLBACK

Platform Guide for Windows, 10g Release 1 (10.1)

4 Postinstallation Configuration Tasks on Windows

Tablespace/Rollback Segment Minimum Free SpaceTable 4-2 Advanced Replication Tablespace/Rollback Segment Requirements Tablespace/Rollback Segment

Platform Guide for Windows, 10g Release 1 (10.1)

4 Postinstallation Configuration Tasks on Windows

4.7.1 Checking Tablespace and Rollback Segment RequirementsRecommended tablespace and rollback segment requirements for Advanced Replication are shown in Table 4-2.