RDBPROD: How to Reduce AIJ Demands When Adding Indexes on Large Tables (Doc ID 549925.1)

Last updated on APRIL 18, 2022

Applies to:

Goal

Creating several large indexes can cause the AIJ to consume all available space, which leads to a database failure with RDMS-F-AIJTERMINATE.  How can the demands on the database AIJ files be reduced when adding large indexes?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.