My Oracle Support Banner

MDS Schema Program Load Failed with Error When Custom Tablespace Name is Defined (Doc ID 2646686.1)

Last updated on MARCH 09, 2020

Applies to:

Oracle Fusion Middleware - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

After configuring mds schema to use a custom tablespace name, product load failed with errors:

Changes

1. In RCU create System Load scripts with "Prepare Script for System Load" option, select a prefix name (using DEV as example).

2. After scripts are created modified script_systemLoad.sql and replace tablespace names with a different prefix, for example: From DEV_MDS to TEST_MDS.

3. Execute script_systemLoad.sql to create the database schemas and objects.

4. In RCU "Perform Product Load" option use the previous selected prefix (DEV).

Issue is reproduced, STB and WLS schemas has no issue, only issue with MDS.

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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