TUX.ALL - ORA-01453 When Attempting to Change the Rollback Segment within an Oracle Transaction (Doc ID 764559.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Tuxedo - Version 9.0 to 11.1.1.2.0
Information in this document applies to any platform.
***Checked for relevance on 10-06-2013***

Goal

The customer wanted to change the rollback segment within an Oracle transaction. Normally, this is done via a SQL statement such as:

 

SET TRANSACTION USE ROLLBACK SEGMENT OBELIX;

This is valid when Oracle is managing the transaction. However, using the same statement when the transaction is started from within a Tuxedo service (with Tuxedo AUTOTRAN=Y configuration or where the service uses tpbegin()) generates the following Oracle error message:

 

01453, 00000, "SET TRANSACTION must be first statement of transaction"

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms