Oracle | DBMS_IMMUTABLE

Oracle DBMS_IMMUTABLE_TABLE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Allows deletion of expired rows in an immutable table

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT

DBMS_BLOCKCHAIN_TABLE_LIB

DBMS_UTILITY

Documented Yes

Exceptions

Error Code	Reason
ORA-05771	<table_name> is not an immutable table

First Available Yes: Packages and Types Reference

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsbctab.sql

Subprograms

ADD_INTERVAL_PARTITIONING

DELETE_EXPIRED_ROWS

ADD_INTERVAL_PARTITIONING(new 23ai)

Undocumented dbms_immutable_table.add_interval_partitioning( schema_name IN VARCHAR2, table_name IN VARCHAR2, interval_number IN NUMBER, interval_frequency IN VARCHAR2, first_high_timestamp IN TIMESTAMP);

TBD

DELETE_EXPIRED_ROWS

Undocumented dbms_immutable_table.delete_expired_rows( schema_name IN VARCHAR2, table_name IN VARCHAR2, before_timestamp IN TIMESTAMP WITH TIME ZONE DEFAULT NULL, number_of_rows_deleted OUT NUMBER);

DECLARE

       delRows INTEGER;

      BEGIN

        dbms_immutable_table.delete_expired_rows('C##UWCLASS', 'AUDIT_LOG', SYSDATE-90, delRows);

        dbms_output.put_line(TO_CHAR(delRows));

      END;

      /

      42