开发者

Liquibase creating index for Oracle fails

开发者 https://www.devze.com 2023-04-02 12:19 出处:网络
I\'m trying to create an index with Liquibase Here is the changeSet <changeSet id=\".... <createIndex tableName=\"xyz\"indexName=\"abc\">

I'm trying to create an index with Liquibase

Here is the changeSet

<changeSet id="....
    <createIndex tableName="xyz"    indexName="abc">
        <column name="column1"/>开发者_运维问答;
    </createIndex>

But I'm getting this error

Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE INDEX .abc ON xyz(column1): ORA-00953: missing or invalid index name

Note: The same liquibase file is processed with PostgreSQL on development and with H2 for unit tests. It's working fine for those databases.


An index name cannot start with .

0

精彩评论

暂无评论...
验证码 换一张
取 消