My Oracle Support Banner

Installing OBI 12c and Using Custom RCU Tablespaces, RCU Fails With "ORA-00959: tablespace 'PREFIX_MDS' does not exist" (Doc ID 2657329.1)

Last updated on APRIL 08, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

You are attempting to use existing tablespaces during the dataload phase of creating your RCU schemas for Oracle Business Intelligence.


This is achieved by following the Repository Utility Guide and using the RCU command-line to use either rcuResponseFile.properties (with each of the custom tablespaces configured and uncommented) or passing the -tablespace, -tempTablespace parameters.

Simplified GUI example:

rcu -interactive -dataload -responseFile /tmp/rcuResponseFile.properties
rcu -interactive -dataload -responseFile /tmp/rcuResponseFile.properties -component BIPLATFORM -tempTablespace SCRIPTTEST_IAS_TEMP -tablespace SCRIPTTEST_BIPLATFORM


The documentation states:
"If you provide a value for a parameter on the command line and in the response file, RCU will use the value provided on the command line."

This errors with:

"ORA-00959: tablespace 'PREFIX_MDS' does not exist"

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
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.