Execute the VIP_BGI_Core_TrDB SQL script file on your oracle DBMS. Verify the results.

E-Bonding Runbook Transaction Database

The E-Bonding Runbook Transaction database contains a small number of tables and (in case of oracle) stored procedures.
E-Bonding Runbook Transaction Database – Tables

• PARTNERDEFINITION
• MESSAGES
• TRANSACTION

(Oracle ONLY) E-Bonding Runbook Transaction Database – Stored Procedures

• UPDATE_MESSAGES
• INSERT_MESSAGES_TRANSACTION

(ORACLE ONLY) Creating the Tablespace

The VIP_BGI_Core_TrDB SQL script requires an existing tablespace and user that has full privileges on the tablespace (owner). The user shall be configured to have the E-Bonding Runbook tablespace as his default tablespace.
The lines below shall give an idea about how to create the tablespace and the user. PLEASE CONSULT AN ORACLE DBA FOR PROPER SETUP!
1) Create the tablespace
 create tablespace BGI
 datafile 'C:\DB-DATA\SSIORA12\DATA\BGISYS.dbf' size 7000M reuse;
 create temporary tablespace BGISTMPSPC tempfile 'C:\DB-DATA\SSIORA12\DATA\BGITEMP.dbf'size 1000M reuse;
2) Create the user
 create user bgi identified by bgi1234
 defaulttablespace BGI
 temporary tablespace BGISTMPSPC
 quota unlimited on BGI;
3) Create a role
 create role ARole_bgi not identified;
4) Set privileges
 grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to ARole_bgi;
5) Grant the role
 grant ARole_bgi to bgi;
 go
6)Connect
 Connect with user bgi to the new tablespace BGI
7)BGI SQL script
 Execute the BGI SQL script VIP_BGI_Core_TrDB.sql