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

Last updated on AUGUST 09, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Alpha
HP OpenVMS Itanium

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms