Oracle数据库如何enable XA
2022-11-06 本文已影响0人
CodingCode
$ su - oracle
$ sqlplus / as sysdba
SQL> @<ORACLE_HOME>/rdbms/admin/xaview.sql
SQL> grant SELECT on DBA_PENDING_TRANSACTIONS to public;
SQL> grant SELECT on v$xatrans$ to public;
SQL> grant SELECT on SYS.V$XATRANS$ to public;
SQL> grant EXECUTE on SYS.DBMS_SYSTEM to public;
SQL> quit
