Urgent.News

What's breaking now, across thousands of outlets.

AI

Oracle AI Database 26ai: Does ROW_MOVEMENT_DEFAULT Work in Enterprise Edition?

Oracle AI Database 26ai introduced the ROW_MOVEMENT_DEFAULT initialization parameter in RU 23.26.2 to control whether row movement is enabled by default for new tables. I tested this feature on Oracle AI Database 26ai Enterprise Edition - 23.26.4.0.0 . The parameter does not enable row movement by default in Enterprise Edition. My test: Oracle AI Database 26ai Enterprise Edition Release…

Oracle AI Database 26ai Enterprise Edition version 23.26.4.0.0 does not enable row movement by default with the ROW_MOVEMENT_DEFAULT initialization parameter. This was tested by setting the parameter to ENABLED, creating a partitioned table, inserting a row, and attempting to update the row's partition key column. The update operation failed with an ORA-14402 error, indicating that row movement is not allowed without it enabled.

Flashbacking the table also failed with ORA-08189, confirming the lack of row movement support in Enterprise Edition.

Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.

Read the original at dev.to →

More in AI

More from Monday 16 November →