Import bug in 8i ...(?)

From: Jarek Palka <jarek_at_kamsoft.com.pl>
Date: Fri, 02 Feb 2001 14:59:46 +0100
Message-ID: <3A7ABD52.C5905874@kamsoft.com.pl>

Scenario is as follows :
Oracle 8i (tested on 8.1.6.1.2 on Netware and 8.1.7 on Win2k)

• users have only quota limited to default tablespace create user AUSR identified by AUSR default tablespace ATBS grant connect,resource to AUSR revoke unlimited tablespace from AUSR alter user AUSR quota unlimited on ATBS

create user BUSR identified by BUSR default tablespace BTBS grant connect,resource to BUSR
revoke unlimited tablespace from BUSR
alter user BUSR quota unlimited on BTBS

In schema AUSR I created table with primary key. I'd like export schema AUSR i import it into BUSR in another tablespace. Table is imported correctly but creating primary key FAILS !

Here is import log details :
IMP-00015: following statement failed because the object already exists:
"ALTER TABLE "TAB" ADD CONSTRAINT "TAB_PK" PRIMARY KEY ("ID") USING
INDEX P"
"CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 10240 NEXT 10240
MINEXTE"
"NTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1
BUFFER_PO"
"OL DEFAULT) TABLESPACE "AUSR" ENABLE NOVALIDATE"
Same dump file (DMP) works correctly with Oracle 8.0.x.

---

Jaroslaw Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice tel. (+48 32) 209-07-05, fax 209-07-15 POLAND Received on Fri Feb 02 2001 - 07:59:46 CST