3.6.4 Create Tables in Oracle Database

Create the tables and schema required by MicroTx Distributed Transactions in Oracle Database using a SQL script only if the Oracle Database user does not have the required privileges, such as ALTER and DELETE. MicroTx Distributed Transactions creates tables automatically if the user has ALTER and DELETE privileges.

Before you begin, ensure that the Oracle Database is running and SQL*Plus or any other Oracle-compatible SQL tool is available to run SQL script.

To create tables and schema required by Transaction Manager for Microservices - Distributed Transactions in Oracle Database:

1. Run the Setup_Microtx.sql file, which is located in the installation_directory/MicroTx-RELEASE/coordinator/tmm/schema_dba folder.
2. Create an entry in the table for the latest release. Run the SQL files located in the schema_dba folder in a chronological order, starting from 24.2.1_MicroTx.sql.