My Oracle Support Banner

How To Solve Error ORA-14766 While Working With Partitioned Table On 11g Release (Doc ID 1663764.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


While working with partitioned table on 11g release, then the error ORA-14766 could occur for two known problem:

1) <Bug 15866428>: "ORA-14766 / ORA-14403 during concurrent partition maintenance".

ORA-14766/ORA-14403 errors may be seen during concurrent partition maintenance operations (PMOPS), in the presence of deferred segment creation.

Use the following query to verify if the deferred segment creation was used:

Interval partitioned tables are particularly likely to be affected when concurrent loads are being performed.


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

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