IMP-9 Corrupted Export Dump May Drop An Existing Table During Import (Doc ID 735794.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 9.0.1.0 to 11.1.0.7 [Release 9.0.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 16-MAY-2012***

Symptoms

imp TC/TC tables=TEST ignore=y file=testcase.dmp 
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing TC's objects into TC
. importing TC's objects into TC
IMP-00009: abnormal end of export file

Permanently reproducible. 

Status - Before initiating the import fails

select owner,object_name,object_type  
from dba_objects where owner='TC';
OWNER OBJECT_NAME                OBJECT_TYP
-------- ------------------------------ --------------
TC     TEST                            TABLE

Executing Import

imp TC/TC tables=TEST ignore=y file=test.dmp 
Export file created by EXPORT:V10.01.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing TC's objects into TC
. importing TC's objects into TC
IMP-00009: abnormal end of export file

Status - After import terminated with IMP-00009

-- Checking the object 
select owner,object_name,object_type 
from dba_objects where owner='TC';
no rows selected
==> The table has been dropped !!! 
select OWNER,OBJECT_NAME,ORIGINAL_NAME,OPERATION 
from dba_recyclebin where  owner='TC';
OWNER OBJECT_NAME                      ORIGINAL_NAME    OPERATION
-------- ----------------------------------------- -------------------- ---------
TC     BIN$VYiLlNpkEVbgRAAUT0T6TQ==$0 TEST                   DROP
 

DIAGNOSTIC SECTION 

Tracing the export using event 10046, level 4 confirms the 'drop table' command.

===================== 
PARSING IN CURSOR #3 len=1238 dep=0 uid=60 oct=1 lid=60 tim=6586687724647
hv=3272068726 ad='95b5fda8'
CREATE TABLE "TEST" ("TERMINAL" VARCHAR2(4) NOT NULL ENABLE,
"SEQUENCE" VARCHAR2(8) NOT NULL ENABLE, "MAP_ID" VARCHAR2(5) NOT NULL ENABLE,
...
<Export recognized corruption and aborts>
...
=====================
PARSING IN CURSOR #3 len=28 dep=0 uid=60 oct=12 lid=60 tim=6586687731025 hv=0
ad='7b11fc08'
DROP TABLE "TEST" <== Confirmation: The export drops the table !!!

Changes

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