Import fails

From: Marcus Behrend <marcus_ffm_at_gmx.de>
Date: 20 Aug 2003 03:28:35 -0700
Message-ID: <7791212c.0308200228.4d417883_at_posting.google.com>

Hi,
first at all: I am a real Oracle-Dummy :)

Here we go. There is a production Oracle-Database on my network with a real small instance running on it. (8i, 8.1.7.4.0, Linux).

I wanted to get a new instance for testing with a snapshot of the data of the production database.

[Quoted]
1. I did an export on the production database without warnings: exp system/blabla file=myexport.dmp log=myexport.log full=y
2. I created with the create-scripts of the productions database in a test-server a new instance with an different name and wanted to do a two step import (first constraints and rows and then indexes without rows and constraints). On the first import I do get two warnings and I do not know how to handle:

imp system/blabla constraints=y indexes=n log=myimport1.log \ file=myexport.dmp fromuser=bestwest touser=bestwest feedback=1000

The import goes on but between the lines there are the following messages:

1.

. . importing table                   "EXCEPTIONS"
Note: table contains ROWID column, values may be obsolete
                                                            0 rows

imported

2.

. . importing table "SEARCH_KEYWORDS"

...................................
                                                        35695 rows

imported
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "SEARCH_KEYWORDS" ADD UNIQUE ("KEYWORD") USING INDEX
PCTFREE 1"
"0 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 1024000 NEXT 131072
MINEXTENTS 2 "
"MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_PO"
"OL DEFAULT) TABLESPACE "TS_XRED" ENABLE"
IMP-00003: ORACLE error 2299 encountered ORA-02299: cannot validate (BESTWEST.SYS_C001782) - duplicate keys found

What do I have to do to get a working import?

thx in advance,

Marcus Received on Wed Aug 20 2003 - 12:28:35 CEST