ORA-02074: 'cannot analyze table' calling a package from perl
I got this error running an analyze from within a package called by perl:
[Oracle][ODBC][Ora]ORA-02074: cannot ANALYZE TABLE in a distributed transaction
It’s basically the same issue as descibed in the link - you have to turn off the Microsoft Distributed Transaction Server, as follows:
- fire up the Microsoft ODBC Administrator
- Select the System DSN Tab
- Select the DSN that it’s using
- Click Configure
- Select the Workarounds Tab
- click Disable Microsoft Transaction Server.
You have to go into Microsoft ODBC Administrator