Impdp Fails With ORA-600 [KUPFIREADBZLOB] Using a Dump File Exported From z/OS (Doc ID 760228.1)

Last updated on OCTOBER 09, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

   Dumpfile exported with expdp on z/OS using compression cannot be imported on an ASCII platform (Unix / Windows) and vice versa. Impdp generates the ORA-600 [kupfiReadBzLob] error.  

   The generated trace file contains:
ksedmp: internal or fatal error 
ORA-00600: internal error code, arguments: [kupfiReadBzLob], [kgcddo error],  [19], [1], [2], [0], [], []
---- Current SQL statement for this session ---
BEGIN 
SYS.KUPW$WORKER.MAIN('SYS_IMPORT_TABLE_02', 'SCOTT'); 
END;


----- Call Stack Trace -----
ksedst ksedmp ksfdmp kgerinv kserin kupfiReadBzLob kupfxReadLob spefcmpa spefmccallstd pextproc PGOSF284_peftrust psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexecv8 kpuexec OCIStmtExecute kupprdp opirip opidrv sou2o opimai_real main libc_start_main

Changes

COMPRESSION=METADATA_ONLY is the default opition for expdp and each user who makes a cross-platform expdp/impdp between an EBCDIC platform and ASCII platform will run into this error.

Cause

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