Troubleshooting
Problem
Attempts to upgrade IBM Rational RequisitePro Schema on Oracle Database results in the error "ORA-01950: no privileges on tablespace REQPROTST_INDEX".
Symptom
In the OracleSchemaUpgrade.log you will see the following error:
ERROR at line 1:
ORA-01950: no privileges on tablespace 'REQPROTST_INDEX
Cause
Insufficient privileges on Rational RequisitePro database
Resolving The Problem
Steps to resolve this issue:
- Log in to Oracle Database as Administrator
- Run the following statement:
ALTER USER <user name> QUOTA UNLIMITED ON 'REQPROTST_INDEX'
Note: Replace <user name> with the username used for upgrading the Rational RequisitePro Schema.
[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database: Oracle","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1.1;7.1.1.1;7.1.1.2;7.1.1.3;7.1.1.4;7.1.1.5;7.1.1.6;7.1.1.7;7.1.1.8;7.1.1.9;7.1.2;7.1.2.1;7.1.2.2;7.1.2.3;7.1.2.4;7.1.2.5;7.1.2.6;7.1.2.7;7.1.3;7.1.3.1;7.1.3.2;7.1.3.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21607462