My Oracle Support Banner

Few Demantra Tables Not Using DEMANTRA User Default Tablespace Get ORA-01950: no privileges on tablespace (Doc ID 2278563.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Demantra Demand Management - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5.1 version, Technical

ACTUAL BEHAVIOR
---------------
Customer installed Demantra 12.2.5.1 and used DEMANTRA_SALES_DATA as default tablespace for DEMANTRA schema.

They are getting frequent tabelspace privileges issues referring to APPS_TS_TX_DATA tablespace as follows.
ORA-01950: no privileges on tablespace 'APPS_TS_TX_DATA'

They did some research and found that 55 tables of DEMANTRA schema are using APPS_TS_TX_DATA default tablespace instead of DEMANTRA_SALES_DATA tablespace which is selected during the Installation.

SQL> select default_tablespace, temporary_tablespace,username from dba_users where username='DEMANTRA';

DEFAULT_TABLESPACE TEMPORARY_TABLESPACE USERNAME
------------------------------

DEMANTRA_SALES_DATA TEMP DEMANTRA

SQL> select distinct tablespace_name,count(*) from dba_tables where owner='DEMANTRA' group by tablespace_name;

TABLESPACE_NAME COUNT(*)
----------
APPS_TS_TX_DATA 55
DEMANTRA_SALES_DATA 1113
  23

55 tables are not using default tablespace.

SQL> select owner,table_name,TABLESPACE_NAME from dba_tables where owner='DEMANTRA' and tablespace_name='APPS_TS_TX_DATA';


55 rows selected.


The parameters in the sys_params table also point to the right values

PNAME PVAL
----------------------------------------------------------------------------------------------------
simulationspace DEMANTRA_SIM_DATA
simulationindexspace DEMANTRA_SIM_IDX
sales_data_engine_space DEMANTRA_ENGINE_IDX
sales_data_engine_index_space DEMANTRA_ENGINE_DATA
tablespace DEMANTRA_SALES_DATA

 

EXPECTED BEHAVIOR
-----------------------
Expect that Demantra tables use the default tablespscae defined during installation for all Demantra tables

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Do a demantra install and define default tables spaces for demantra tables
2. Access the application and use it


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot access all of the functionality due to permission issues on the tablespace

Changes

 

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