sqlalchemy orm ddl（cx_oracle.databaseerror）ora-00904 ::无效标识符

Question

我已经根据 sqlAlchemy 文档准备了测试用例： https://docs.sqlalchemy.org/en/ 14/orm/tutorial.html#declare-a-mapping

安装版本：

cx-Oracle==8.2.1
psycopg2-binary==2.9.1
SQLAlchemy==1.4.21

数据库版本：

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

DDL：

import urllib

from sqlalchemy.orm import declarative_base
from sqlalchemy import Column, Integer, String
from sqlalchemy import create_engine


Base = declarative_base()


class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(VARCHAR2(10))
    fullname = Column(VARCHAR2(10))
    nickname = Column(VARCHAR2(10))

    def __repr__(self):
       return "<User(name='%s', fullname='%s', nickname='%s')>" % (
                            self.name, self.fullname, self.nickname)
PASSWORD = 'pass'

conn_str = (f"oracle+cx_oracle://AIM:{urllib.parse.quote_plus(PASSWORD)}@host:1521/?service_name=service")

engine = create_engine(conn_str)
Base.metadata.create_all(engine)

我得到了非常奇怪的错误：

sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-00904: : invalid identifier
[SQL: 
CREATE TABLE users (
    PRIMARY KEY (id)
)

]
(Background on this error at: https://sqlalche.me/e/14/4xp6)