1. Transaction Manager for Microservices Developer Guide
  2. Prepare
  3. Set Up Oracle Database as Data Store
  4. Create Tables in Oracle Database

3.7.3 Create Tables in Oracle Database

Create the tables and schema required by MicroTx 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 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 in Oracle Database:
  1. Run the Setup_Microtx.sql file, which is located in the installation_directory/otmm-RELEASE/otmm/dba_scripts folder.
  2. Create an entry in the table for the latest release. Run the SQL files located in the dba_scripts folder in a chronological order, starting from 24.2.1_MicroTx.sql.

Parent topic: Set Up Oracle Database as Data Store