the error was: ORA-00904: "USER_TAB_COLS"."COLLATION": invalid identifier

akipkemei

Hi,

I'm having this error as I try to inspectdb or make migration Oraclebd.

PLease assist with a quick fix.

C:\inetpub\wwwroot\mysite>python manage.py inspectdb
# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey and OneToOneField has `on_delete` set to the
ired behavior
#   * Remove `managed = False` lines if you wish to allow Django to create,
fy, and delete the table
# Feel free to rename the models, but don't rename db_table values or field
s.
from django.db import models
# Unable to inspect table 'cdr_types'
# The error was: ORA-00904: "USER_TAB_COLS"."COLLATION": invalid identifier
# Unable to inspect table 'cell_hourly_voice'
# The error was: ORA-00904: "USER_TAB_COLS"."COLLATION": invalid identifier
# Unable to inspect table 'cell_id_new'
# The error was: ORA-00904: "USER_TAB_COLS"."COLLATION": invalid identifier

sean

akipkemei

It's possible that the version of Django you're using doesn't support inspectdb for Oracle databases. For example, the [docs for Django v2.0 show that inspectdb only works with PostgreSQL, MySQL and SQLite.
It's possible that you're using a version of Oracle that isn't compatible with your version of Django
I'm not familiar with Oracle, but "USER_TAB_COLS" seems like a system table to me. If that's missing then it's possible that your database is broken.

stephan0h

Hi,
Had the same problem, could solve it like described here:
https://stackoverflow.com/questions/51598599/ora-00904-identity-column-invalid-identifier-error-using-inspectdb-django/60887463#60887463
So you need to downgrade your version of Django - or, as I did, install the old version specifically on this behalf ...
kind regards,
Stephan