Issue while doing migrations to Oracle Database using Django

Question

I am building a Django app and it has several apps. It is working fine with SQLite database as a backend. When I am trying to migrate the backend to Oracle using "manage.py migrate", I am getting below error

django.db.utils.DatabaseError: ORA-01950: no privileges on tablespace 'XXXXXX'

When I checked my User privileges in the database, it has privileges to create tables, views etc. I tried to execute "manage.py sqlmigrate" and go through the queries that Django is going to execute on the database and found out that they are "create table" and "add constraints queries". Is there a way in Django to find out which query is getting failed or raising that ORA-01950 error?

Lav Patel · Accepted Answer · 2018-10-26 18:38:36Z

2

When I checked my User privileges in the database, it has privileges to create tables, views etc.

Have you checked that app user has permssion related to quota (unlimited or 1GB .. ) ? In oracle, it is not sufficient to have create table permission to create table, you also need quota on table space.

ALTER USER <user> quota unlimited on <tablespace name>;

or

ALTER USER <user> quota 1G on <tablespace name>;

answered Oct 26, 2018 at 18:38

Lav Patel

1,0471 gold badge8 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kumar-58 Over a year ago

I already tried altering the quota, but cannot execute it due to ORA-01031 insufficient privileges. One more thing(forgot to mention in the post) is that I am able to run queries to create tables and views manually

William Robertson Over a year ago

@Kumar-58 Creating an empty table doesn't necessarily use a tablespace. Try inserting a row into a table that you created. If you don't have either a sufficient quota on the tablespace or the UNLIMITED TABLESPACE system privilege them your migration isn't happening.

Kumar-58 Over a year ago

@WilliamRobertson I tried to insert values into one of the tables created in the database. I got similar error ORA-01950 no privileges on tablespace. I will contact my DBA to provide privileges on the tablespace. Thanks for help.

Collectives™ on Stack Overflow

Issue while doing migrations to Oracle Database using Django

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related