My Oracle Support Banner

SOA QuickStart Using Wrong RCU TableSpace Name, Changing It Causes: Error creating PL/SQL Object MDS_INTERNAL_DYNAMIC:PACKAGE (Doc ID 2655848.1)

Last updated on JULY 10, 2020

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.


When installing SOA QuickStart, the RCU is hardcoded to use the wrong tablespace names.


The issue can be reproduced at will with the following steps:
1- Install SOA Suite with fmw_12.
2- Launch RCU to create schemas and generate scripts script_systemLoad.sql and script_postDataLoad.sql
-At this step, specify existing tablespaces for future schemas. (Not desirable to create new schemas for each schemas/user with the new prefix.)
3- Execute script_systemLoad.sql with sysdba user
4- Launch RCU to perform product load
-At this step the tool finds newly created schemas but still wants to work with new tablespaces and ignores those created in step 2. Change them again to fit with the existing tablespaces.
-Last step of product load fails because the tool doesn't find some objects. RCU still looks for some object in default namespaces instead of those newly created.


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.