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 En
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 23.26.4.0.0 - Production
Version 23.26.4.0.0
SQL> alter system set row_movement_default=ENABLED;
System altered.
SQL> show parameter row_movement_default
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
row_movement_default string ENABLED
SQL> CREATE TABLE vahid.customers (
customer_id NUMBER,
name VARCHAR2(14),
last_name VARCHAR2(14),
registration_date DATE)
PARTITION BY RANGE (registration_date)
(
PARTITION customers_2024 VALUES LESS THAN (DATE '2025-01-01'),
PARTITION customers_2025 VALUES LESS THAN (DATE '2026-01-01'),
PARTITION customers_max VALUES LESS THAN (MAXVALUE)
);
Table created.
SQL> INSERT INTO vahid.customers VALUES
( 1, 'Vahid', 'Yousefzadeh', DATE '2024-06-15' );
1 row created.
SQL> commit;
Commit complete.
SQL> UPDATE vahid.customers
SET registration_date = DATE '2025-06-15'
WHERE customer_id = 1;
ORA-14402: updating partition key column would cause a partition change
SQL> FLASHBACK TABLE vahid.customers TO TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' MINUTE);
ERROR at line 1:
ORA-08189: cannot flashback the table because row movement is not enabled
Originally published by Dev.to AI. Aggregated on AIWithGhost for educational purposes β full credit and traffic to the original publisher.