DataPump Import (IMPDP) Fails With Errors ORA-2372 ORA-26093 ORA-2374
DataPump Import (IMPDP) Fails With Errors ORA-2372 ORA-26093 ORA-2374
Titleimage
Posted by Patrick Hamou on 2017:09:06 14:47:45
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2014***
SYMPTOMS
During DataPump import you received the following oerrors:
ORA-02372: data for row: COLLECTION : 0X'050200'"
ORA-26093: input data column size (3) exceeds the maximum input size (1)
ORA-02374: conversion error loading table "MJSDEV"."COLLECTION
CAUSE
Bug 13424216 - ERRORS ORA-02372 ORA-26093 ORA-02374 DURING DATAPUMP IMPORT
This has been traced back to a problem with the column length of Object Type Columns.
The bug is a.o. fixed in
12.1.0.1 (Base Release)
11.2.0.4 (Server Patch Set)
Please refer to
Note 13424216.8 - Bug 13424216 - ERRORS ORA-02372 ORA-26093 ORA-02374 DURING DATAPUMP IMPORT
SOLUTION
To solve the issue, use any of below alternatives:
o Upgrade to 12c
- OR -
o Apply patch setv 11.2.0.4
- OR -
o Apply interim patch 13424216, if available for your platform and RDBMS version.
To check for conflicting patches, please use the MOS Patch Planner Tool
Please refer to
Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?
REFERENCES
BUG:13424216 - ERRORS ORA-02372 ORA-26093 ORA-02374 DURING DATAPUMP IMPORT
NOTE:13424216.8 - Bug 13424216 - ORA-2372 / ORA-26093 ORA/-2374 during datapump import
Posted by Patrick Hamou on 2017:09:06 14:47:45