My Oracle Support Banner

ORA-04025: Maximum Allowed Library Object Lock Allocated For INSERT /*+ NO_DST_UPGRADE_INSERT_CONV I (Doc ID 2696421.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

 DBMS_REDEFINITION.START_REDEF_TABLE fails with:

 

error in materialized view log on <<<primary table name>>
ORA-04025:
maximum allowed library object lock allocated for INSERT /*+ NO_DST_UPGRADE_INSERT_CONV IDX(0) */ INTO "<(dmltype$$,old_new$$,snap@


Changes

 NA

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


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