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
Press enter or click to view image in full size

Comments

Popular posts from this blog

Oracle 21c Enhancements for TTS Export/Import

Oracle 23ai — error_message_details Parameter for Displaying Error Details

Buffer Busy Wait and Read by Other Session in Oracle