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 27, 2024

Applies to:

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


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


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.



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.