My Oracle Support Banner

Database upgrade fails with Error:" ORA-01950: no privileges on tablespace 'USERS'" (Doc ID 2498495.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Database upgrade to 12.2.0.1 fails with error:

Shown in catupgr0.log

SQL> ALTER SESSION SET CURRENT_SCHEMA = gsmadmin_internal;
..

SQL> -- re-create primary key
SQL> BEGIN
  2       EXECUTE IMMEDIATE 'ALTER TABLE database DROP PRIMARY KEY';
  3       EXECUTE IMMEDIATE 'ALTER TABLE database
  4          ADD PRIMARY KEY(database_num)';
  5  EXCEPTION
  6       WHEN OTHERS THEN
  7          IF SQLCODE IN (-02273 , -02260 ) THEN NULL;
  8          ELSE RAISE;
  9          END IF;
 10  END;
 11  /
BEGIN
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'
ORA-06512: at line 8
ORA-06512: at line 3
..
..

SQL>
SQL> BEGIN
  2       EXECUTE IMMEDIATE 'ALTER TABLE gsm_requests
  3          ADD PRIMARY KEY(change_seq#)';
  4  EXCEPTION
  5       WHEN OTHERS THEN
  6          IF SQLCODE = -02260 THEN NULL;
  7          ELSE RAISE;
  8          END IF;
  9  END;
 10  /
BEGIN
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'
ORA-06512: at line 7
ORA-06512: at line 2
..
..
..

SQL> ALTER SESSION SET CURRENT_SCHEMA = APPQOSSYS;

..
QL> CREATE TABLE wlm_feature_usage
 2  (
 3       timestamp         TIMESTAMP,
 4       modebtime         TIMESTAMP,
 5       curmode         NUMBER,
 6       prevmode         NUMBER,
 7       maxpc             NUMBER,
 8       curnumpc         NUMBER,
 9       managed         NUMBER,
10       measureonly         NUMBER,
11       monitor         NUMBER,
12       managed_cumtime     INTERVAL DAY(9) to SECOND(0),
13       measureonly_cumtime INTERVAL DAY(9) to SECOND(0),
14       monitor_cumtime     INTERVAL DAY(9) to SECOND(0),
15       used             NUMBER,
16       stats1          NUMBER,
17       stats2          NUMBER,
18       stats3          NUMBER,
19       feature_info         VARCHAR2(4000)
20  )
21  /
CREATE TABLE wlm_feature_usage
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'



 

 

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.