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 and later
Information in this document applies to any platform.


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 (with each of the custom tablespaces configured and uncommented) or passing the -tablespace, -tempTablespace parameters.

Simplified GUI example:

rcu -interactive -dataload -responseFile /tmp/
rcu -interactive -dataload -responseFile /tmp/ -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"


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.