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:

Symptoms

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

Cause

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