"Ora-00955: Name Is Already Used By An Existing Object" Even With IGNORE=Y (Doc ID 802874.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7
This problem can occur on any platform.

Symptoms

When performing import with IGNORE=Y,the following errors are encountered..

IMP-00017: following statement failed with ORACLE error 604:
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-06531: Reference to uninitialized collection
ORA-06512: at line 46
ORA-00955: name is already used by an existing object

 

 

-- Steps To Reproduce:

imp username/password IGNORE=Y file=exp.dmp log=imp.log

Example:

$ imp userid=system file=test1.dmp fromuser=cis touser=ops\$oracle ignore=y

Import: Release 11.1.0.7.0 - Production on Wed Apr 1 17:47:40 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.01.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. importing CIS's objects into OPS$ORACLE
IMP-00017: following statement failed with ORACLE error 604:
"CREATE TABLE "TEST_TAB" ("ID" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 2097152 NEXT 2097152 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "CIS_COMMON" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-06531: Reference to uninitialized collection
ORA-06512: at line 46
ORA-00955: name is already used by an existing object
Import terminated successfully with warnings. 


 

 

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