Skip to main content

Upgrading Rational RequisitePro Schema on Oracle results in "ORA-01950: no privileges on tablespace REQPROTST_INDEX" error


Technote (troubleshooting)


Problem(Abstract)

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:

  1. Log in to Oracle Database as Administrator
  2. 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:

(0 users)Average rating

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.

Rate this page:


(0 users)Average rating

Add comments

Document information

Rational RequisitePro

Database: Oracle

Software 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

Operating system(s):
Windows

Reference #:
1607462

Modified date:
2012-10-22

Translate my page

Content navigation