aug70co
aug70co

Reputation: 3987

Liquibase creating index for Oracle fails

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.

Upvotes: 0

Views: 1280

Answers (1)

steve
steve

Reputation: 6020

An index name cannot start with .

Upvotes: 2

Related Questions