Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#20707 closed Bug (fixed)

manage.py test failed with error ORA-01950 when use Oracle 12c

Reported by: sns1081@… Owned by: nobody
Component: Database layer (models, ORM) Version: master
Severity: Normal Keywords: oracle
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

When using new release Oracle 12c creating test user broken with error DatabaseError: ORA-01950: no privileges on tablespace 'TEST_V8'
It happens because UNLIMITED TABLESPACE is no longer included in RESOURCE role. Quota must be explicitly set by ALTER USER test_user QUOTA UNLIMITED ON test_tablespace after creating test user but before load any data.

Change History (6)

comment:1 Changed 3 years ago by Tim Graham

Has patch: set
Keywords: oracle added
Triage Stage: UnreviewedAccepted
Version: master

comment:2 Changed 3 years ago by Shai Berger <shai@…>

Resolution: fixed
Status: newclosed

In e4274e3da1160997bc78c09ca8f634e04d7438d2:

[1.6.x] Fixed #20707 -- Added explicit quota assignment to Oracle test user
To enable testing on Oracle 12c

comment:3 Changed 3 years ago by Shai Berger <shai@…>

In aa50b7e8373031838c4d1d5fa7da809d3c20dc23:

[1.5.x] Fixed #20707 -- Added explicit quota assignment to Oracle test user
To enable testing on Oracle 12c

comment:4 Changed 3 years ago by Shai Berger <shai@…>

In 9ab7ed9b726a2bb0eee1d89327b9bf7ea75bba38:

[1.4.x] Fixed #20707 -- Added explicit quota assignment to Oracle test user
To enable testing on Oracle 12c

comment:5 Changed 3 years ago by Shai Berger <shai@…>

In 1185370c2c7e66428c45c69e960d10198e17e367:

Fixed #20707 -- Added explicit quota assignment to Oracle test user
To enable testing on Oracle 12c

comment:6 Changed 3 years ago by Shai Berger

Just to set the record straight -- The commits mentioned in the above comments are all made from PR 1336 mentioned above.

Thanks nsadovskiy for report and fix.

Note: See TracTickets for help on using tickets.
Back to Top