django在migrate时报错ORA-02000: missing ALWAYS keyword

原创

于 2019-08-17 18:35:44 发布 · 5.3k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#django #oracle #python

在使用Django 2.2.4与Oracle 11.2.0.4数据库进行migrate时遇到ORA-02000错误。错误源于在11g中使用了Oracle 12c的Always关键字。尝试降级cx_oracle版本未果，最终通过升级Oracle到12.1.0.2并更新Django和cx_oracle到最新版本成功解决问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误信息

在这里插入图片描述

PS D:\parttime\python\django\guanxiangzhiji> python manage.py migrate
Operations to perform:
  Apply all migrations: admin, auth, contenttypes, sessions
Running migrations:
Traceback (most recent call last):
  File "D:\app\anaconda\lib\site-packages\django\db\backends\utils.py", line 82, in _execute
    return self.cursor.execute(sql)
  File "D:\app\anaconda\lib\site-packages\django\db\backends\oracle\base.py", line 510, in execute
    return self.cursor.execute(query, self._param_generator(params))
cx_Oracle.DatabaseError: ORA-02000: missing ALWAYS keyword

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "D:\app\anaconda\lib\site-packages\django\db\migrations\recorder.py", line 67, in ensure_schema
    editor.create_model(self.Migration)
  File "D:\app\anaconda\lib\sit