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

Add comments

Document information


More support for:

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

Machine Translation

Content navigation