DROP PARTITION Fails With ORA-29919, ORA-20000, DRG-50857, ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
(Doc ID 3079554.1)
Last updated on MARCH 31, 2025
Applies to:
Oracle Text - Version 19.22.0.0.0 and laterOracle Database - Enterprise Edition - Version 19.22.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
Dropping a partition of a table with a local partitioned SEARCH INDEX with SYNC EVERY fails with errors:
The issue does not occur if the index is SYNC ON COMMIT.
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 |