OHF: ORA-01950: no privileges on tablespace <Tablespace>
(Doc ID 2316625.1)
Last updated on DECEMBER 15, 2024
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
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 |