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 FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Goal

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.

Solution

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
Goal
Solution
References


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