Attempts to upgrade IBM Rational RequisitePro Schema on Oracle Database results in the error "ORA-01950: no privileges on tablespace REQPROTST_INDEX".
In the OracleSchemaUpgrade.log you will see the following error:
ERROR at line 1:
ORA-01950: no privileges on tablespace 'REQPROTST_INDEX
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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.