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 laterInformation 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'
..
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 |