Opened 2 years ago

Closed 22 months ago

Last modified 22 months 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 23 months ago by timo

  • Has patch set
  • Keywords oracle added
  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Triage Stage changed from Unreviewed to Accepted
  • Version set to master

comment:2 Changed 22 months ago by Shai Berger <shai@…>

  • Resolution set to fixed
  • Status changed from new to closed

In e4274e3da1160997bc78c09ca8f634e04d7438d2:

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

comment:3 Changed 22 months 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 22 months 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 22 months 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 22 months ago by shai

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