Schema Changes in Migration fails with Error ORA-00054 and Require Downtime
(Doc ID 2700211.1)
Last updated on MARCH 26, 2024
Applies to:
Siebel CRM - Version 17.0 [IP2017] and laterInformation in this document applies to any platform.
Symptoms
DDLImport fails with below error and needs downtime during the migration when schema changes are migrated :
2020-06-20 11:50:52 SQL Statement: alter index S_EVT_ACT_F111_X noparallel logging
2020-06-20 11:50:52 [1076673536][ODBC Oracle driver][Oracle]ORA-00054:resource busy and acquire with NOWAIT specified or timeout expired
2020-06-20 11:50:52 Dropping index with the same column signature and retrying...
2020-06-20 11:50:52 alter index S_EVT_ACT_F111_X noparallel logging
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |