OHF: ORA-01950: no privileges on tablespace <Tablespace>

(Doc ID 2316625.1)

Last updated on NOVEMBER 03, 2017

Applies to:

Oracle Healthcare Foundation - Version 7.1.1 to 7.1.2 [Release 7.1]
Information in this document applies to any platform.

Symptoms

The OHF 7.1.1 upgrade fails with the following error message in the install.err log:

***************************************************************************************************************
Line 844452: FAIL 2166: 'ORA-01950: no privileges on tablespace '<TABLESPACE_NAME>'', Rule 'pragma err forever ^ORA-.*'
***************************************************************************************************************
28 "ETL_PROC_WID" NUMBER(38,0),
29 "INTEGRATION_ID" VARCHAR2(400),
30 "ENTERPRISE_ID" NUMBER,
31 "SET_ID" VARCHAR2(30)
32 )
33 PARTITION BY RANGE ("W_INSERT_DT") INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
34 (PARTITION "P0" VALUES LESS THAN (TO_DATE(' 2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ) ;
CREATE TABLE "W_HCD_ADMNSTRD_SURVEY_F"
*
ERROR at line 1:
ORA-01950: no privileges on tablespace '<TABLESPACE_NAME>'

You notice that several CREATE TABLE STATEMENTS are failing with this error.

Cause

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