Oracle DB seed database
Description
The Oracle database seed dump in the repository, contains some wrong constraints i.e.:
M_INVENTORYLINEMA_KEY
M_INOUTLINEMA_KEY
I think there are an errors in migration script: 201310141246_IDEMPIERE-386.sql
i.e. there is this
ALTER TABLE M_InOutLineMA DROP CONSTRAINT m_inoutlinema_key
instead of
DROP INDEX M_INOUTLINEMA_KEY;
Best regards
Environment
Oracle XE 11G
Activity
I have encountered the same problem.
If I understand correct Oracle is creating also an index when you create a primary key constraint. When you drop the constraint, the index is not droped automatically.
I have attached a migration for Oracle which takes care and works even if you had already manually droped the index.
I think for the future people have just to remember this and take care that besides the constraint they also drop a related index.
WDYT?
Regards,
Dirk Niemeyer
Thanks , committed a version with direct DROP because in my tests with syncApplied it didn't work the pl/sql version.
