My Oracle Support Banner

How To Transition From MultiDB To MultiSchema (Doc ID 2766936.1)

Last updated on APRIL 14, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.




The production environment is currently running on multiDB configuration but we would like to transition to multiSchema instead.
The setup is 3 schemas. pin01 being the primary. pin02 and pin03 are secondary schemas.
Are these steps listed below are sufficient and safe to perform the transition?

1.Add following lines in /appl/portal/7.5/setup/scripts/pin_multidb.conf:
2: execute expect pin_multidb.expect
3: execute perl -R all
4: check on schemas pin02 and pin03:
 - materialized views were dropped
 - views were created

5: Replace the follwing in dm_oracle pin.conf (example for pin03)
  - dm primary_schema PIN01\n- dm schema PIN01
  - dm schema PIN01\n- dm schema PIN02


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

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

In this Document

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