Dev.to AI πŸ€– Ai πŸ‘ 0 πŸ“– 1 min read

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: 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 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

πŸ“° Read the original article on Dev.to AI

Originally published by Dev.to AI. Aggregated on AIWithGhost for educational purposes β€” full credit and traffic to the original publisher.