Enable Microsoft Transaction Server in ODBC client side cause direct path load not work
(Doc ID 2353035.1)
Last updated on NOVEMBER 20, 2019
Applies to:Oracle Database - Standard Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
- After migrated from Windows 2008 R2 server to Windows 2012, the SQL statements of insert /+ append */ ...
and create table ... as select ... become slower though both environments have the same data.
In the new environment, the Microsoft Transaction Server (MTS) in ODBC client side was enabled.
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