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

Last updated on MAY 12, 2017

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

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