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
ROLLBACK → Purpose 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
rollback() → Drops all changes made since the previous commit or rollback, and releases any database locks currently held by the session. Syntax void rollback();
Rollback Segments → In 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.
ROLLBACK Statement → The 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
ROLLBACK Procedure → This procedure is equivalent to the SQL statement: ROLLBACK This procedure is included for
DROP ROLLBACK SEGMENT → Purpose 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.
Restrictions on Dropping Rollback Segments → You 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
CREATE ROLLBACK SEGMENT → using 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
ALTER ROLLBACK SEGMENT → using 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
IDAP Rollback Response → The response to a rollback request uses the AQXmlRollbackResponse method, which consists of
Statement-Level Rollback → rolled 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,
Rollback of Transactions → uncommitted 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
Using the ROLLBACK Statement → ROLLBACK 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
Commit or Rollback → An 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()
ROLLBACK (Executable Embedded SQL) → Purpose To undo work done in the current transaction.
3.8 The ROLLBACK 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 … complete (a SQL statement might not execute successfully, for example), ROLLBACK lets you return to the … ROLLBACK
3.7 Using the ROLLBACK 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 flow of … control in your program. Specifically,
18 SQL Statements: DROP SEQUENCE to ROLLBACK → FLASHBACK TABLE GRANT INSERT LOCK TABLE MERGE NOAUDIT PURGE RENAME REVOKE ROLLBACK
Tablespace/Rollback Segment Minimum Free Space → Table 4-2 Advanced Replication Tablespace/Rollback Segment Requirements Tablespace/Rollback Segment
4.7.1 Checking Tablespace and Rollback Segment Requirements → Recommended tablespace and rollback segment requirements for Advanced Replication are shown in Table 4-2.