Hi,
I tried to recreate INDEX from DATABASE like this
UPDATE DATABASECHANGELOG SET DATEEXECUTED = SYSTIMESTAMP, DEPLOYMENT_ID = NULL, EXECTYPE=‘RERAN’ WHERE ID IN(SELECT ID FROM DATABASECHANGELOG where DESCRIPTION LIKE ‘%createIndex indexName=IDX_FLIGHT__, %’);
But my Index are not created Why ?
I use Liquibase 3.6.3
Regards
I have no idea what sql is in your changeset, or if the index already exists, so that makes providing a useful recommendation very difficult, so in general here is what I would recommend.
I would normally recommend to never manually update the databasechangelog table, but I think in this situation (assuming the index does not exist in the database) I would just delete the changeset record from the databasechangelog table. That will cause Liquibase to execute the changeset again.
