My Oracle Support Banner

Consolidating Multiple TUGBU Application Module Database Schemas (Doc ID 1340462.1)

Last updated on MAY 23, 2019

Applies to:

Oracle Public Sector Revenue Management - Version 2.1.5 and later
Oracle Utilities Customer Care and Billing - Version 1.5.20 and later
Oracle Utilities Business Intelligence - Version DNU2.2.1 and later
Oracle Financial Services Revenue Management and Billing - Version DNU2.2.1 and later
Oracle Utilities Meter Data Management - Version DNU4.53 and later
Information in this document applies to any platform.


**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
MDM - Oracle Utilities Meter Data Management
MWM - Oracle Utilities Mobile Workforce Management
UAT - User Acceptance Testing
RAC - Oracle Real Application Clusters
CIS - Customer Information System

The current CIS project requires multiple schemas for each module (CCB, MWM, MDM). It also has multiple non-production environments for different stages (DEMO, DEV, TRAINING, CONERSION, STATGIN, TEST, IST, UAT....).

Can all these non-production database schemas be consolidated in the same database instance, or three database instances (CCB, MWM, MDM), one for each functional module. Rather than 3 application x 10 environments = 30 instances (60 instances for RAC configuration ).


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.