Recommendation To Maintain The Demantra Objects Tablespace (Doc ID 2187299.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Advanced Forecasting and Demand Modeling - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

Customer mentions that when they did the install they just used one tablespace
Now they want to split the tables in different tablespaces as per the details in the install guide as below

If you are performing a new installation, create tablespaces within Oracle for use by the Oracle Demantra database user. Oracle
recommends that you set up tablespaces with the following names:
• TS_SALES_DATA
• TS_SALES_DATA_X
• TS_SALES_DATA_ENGINE
• TS_SALES_DATA_ENGINE_X

You will need up to eight tablespaces. These four contain the data that is most commonly shared with Oracle Demantra

They are looking for guidance as to what tables needs to be moved to these tablespaces? Right now they have one tablespace i.e DMT_DATA and DMT_IDX for all Demantra tables.


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms