My Oracle Support Banner

Database Extract fails with "ORA-01453: SET TRANSACTION must be first statement of transaction" (Doc ID 1916248.1)

Last updated on DECEMBER 11, 2019

Applies to:

Siebel CRM - Version 7.8.2 SIA [19213] and later
Information in this document applies to any platform.


When Database Extract (DbXtract) was started, it failed at "Part 4: Deleting from temporary tables" with the following information.


  Part 4: Deleting from temporary tables...

SQLError    Statement   0     0000000853e90868:0      2014-08-11 11:06:03     SQL Statement:

BEGIN loop delete from SIA81.S_DOCK_INITM_01 where rownum < 2000 and NODE_ID = '1-9I6';set transaction use rollback segment ta; exit when SQL%rowcount = 0;commit;end loop;commit; END;

DBCLog      DBCLogError 1     0000000853e90868:0      2014-08-11 11:06:03      [DataDirect][ODBC Oracle driver][Oracle]ORA-01453: SET TRANSACTION must be first statement of transaction

ORA-06512: at line 1


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.