[Django] #20707: manage.py test failed with error ORA-01950 when use Oracle 12c

Django

unread,

Jul 5, 2013, 7:00:08 AM7/5/13

to django-...@googlegroups.com

#20707: manage.py test failed with error ORA-01950 when use Oracle 12c
----------------------------------------------+--------------------
Reporter: sns1081@… | Owner: nobody
Type: Bug | Status: new
Component: Database layer (models, ORM) | Version:
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+--------------------
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.

--
Ticket URL: <https://code.djangoproject.com/ticket/20707>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,

Aug 16, 2013, 9:39:19 AM8/16/13

to django-...@googlegroups.com

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

-------------------------------------+-------------------------------------

Reporter: sns1081@… | Owner: nobody
Type: Bug | Status: new

* needs_better_patch: => 0
* needs_tests: => 0
* version: => master
* keywords: => oracle
* needs_docs: => 0
* has_patch: 0 => 1
* stage: Unreviewed => Accepted

Comment:

https://github.com/django/django/pull/1333
https://github.com/django/django/pull/1336

--
Ticket URL: <https://code.djangoproject.com/ticket/20707#comment:1>

Django

unread,

Sep 9, 2013, 9:27:32 AM9/9/13

to django-...@googlegroups.com

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

-------------------------------------+-------------------------------------
Reporter: sns1081@… | Owner: nobody
Type: Bug | Status: closed

Component: Database layer | Version: master

(models, ORM) | Resolution: fixed

Changes (by Shai Berger <shai@…>):

* status: new => closed
* resolution: => fixed

Comment:

In [changeset:"e4274e3da1160997bc78c09ca8f634e04d7438d2"]:
{{{
#!CommitTicketReference repository=""
revision="e4274e3da1160997bc78c09ca8f634e04d7438d2"
[1.6.x] Fixed #20707 -- Added explicit quota assignment to Oracle test
user
To enable testing on Oracle 12c
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/20707#comment:2>

Django

unread,

Sep 9, 2013, 9:27:32 AM9/9/13

to django-...@googlegroups.com

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

-------------------------------------+-------------------------------------
Reporter: sns1081@… | Owner: nobody

Comment (by Shai Berger <shai@…>):

In [changeset:"aa50b7e8373031838c4d1d5fa7da809d3c20dc23"]:
{{{
#!CommitTicketReference repository=""
revision="aa50b7e8373031838c4d1d5fa7da809d3c20dc23"
[1.5.x] Fixed #20707 -- Added explicit quota assignment to Oracle test

user
To enable testing on Oracle 12c
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/20707#comment:3>

Django

unread,

Sep 9, 2013, 9:27:37 AM9/9/13

to django-...@googlegroups.com

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

-------------------------------------+-------------------------------------
Reporter: sns1081@… | Owner: nobody

Comment (by Shai Berger <shai@…>):

In [changeset:"9ab7ed9b726a2bb0eee1d89327b9bf7ea75bba38"]:
{{{
#!CommitTicketReference repository=""
revision="9ab7ed9b726a2bb0eee1d89327b9bf7ea75bba38"
[1.4.x] Fixed #20707 -- Added explicit quota assignment to Oracle test

user
To enable testing on Oracle 12c
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/20707#comment:4>

Django

unread,

Sep 9, 2013, 9:27:41 AM9/9/13

to django-...@googlegroups.com

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

-------------------------------------+-------------------------------------
Reporter: sns1081@… | Owner: nobody

Comment (by Shai Berger <shai@…>):

In [changeset:"1185370c2c7e66428c45c69e960d10198e17e367"]:
{{{
#!CommitTicketReference repository=""
revision="1185370c2c7e66428c45c69e960d10198e17e367"

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

--
Ticket URL: <https://code.djangoproject.com/ticket/20707#comment:5>

Django

unread,

Sep 9, 2013, 9:41:42 AM9/9/13

to django-...@googlegroups.com

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

-------------------------------------+-------------------------------------
Reporter: sns1081@… | Owner: nobody

Comment (by shai):

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