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

观想

于 2019-08-17 18:35:44 发布

阅读量5.3k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： Python 文章标签： django oracle python

本文链接：https://blog.youkuaiyun.com/yoursly/article/details/99695767

在使用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