Database Extract fails with "ORA-01453: SET TRANSACTION must be first statement of transaction"
Last updated on JULY 11, 2017
Applies to:Siebel CRM - Version 7.8.2 SIA  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
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