How To Solve Error ORA-14766 While Working With Partitioned Table On 11g Release
Last updated on MAY 12, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206.0 to 220.127.116.11 [Release 11.2]
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms