ORA-31693 ORA-06502

oracle@rac02:/home/> impdp sys tables=test.test directory=DATAPUMP \ > dumpfile=expdp_test240124.dmp \ > cluster=n \ > content=DATA_ONLY \ > job_name=impdp_test240124 \ > logfile=impdp_test240124.log  Import: Release 11.2.0.4.0 - Production on Wed Jan 24 16:13:43 2024 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Password:  Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Master table "SYS"." impdp_test240124" successfully loaded/unloaded Starting "SYS"." impdp_test240124":  sys/******** AS SYSDBA tables= test.test directory=DATAPUMP dumpfile= expdp_test240124.dmp cluster=n content=DATA_ONLY job_name= impdp_test240124 logfile= impdp_test240124 .log  Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "test"."test" failed to load/unload and is being skipped due to error: ORA-06502: PL/SQL: numeric or value error Job "SYS"." impdp_test240124" completed with 1 error(s) at Wed Jan 24 16:14:08 2024 elapsed 0 00:00:12

 

Bug 18665004 - ORA-31693/ORA-6502 from Datapump import (impdp) into an existing table having a LONG or LONG RAW column (Doc ID 18665004.8)

12.2 하위버전 버그!!!

 

-- 해결방안 

INDEX 싹 다 지우고 TABLE만 생성한 상태에서 IMPDP시 데이터 정상 인입됨.

후에 INDEX 생성!