From: Jarek Palka Newsgroups: comp.databases.oracle.server Subject: Import bug in 8i ...(?) Date: Fri, 02 Feb 2001 14:59:46 +0100 Organization: PIK-Net Sieci Rozlegle - http://www.pik-net.pl Lines: 33 Message-ID: <3A7ABD52.C5905874@kamsoft.com.pl> NNTP-Posting-Host: pc-60.kamsoft.com.pl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: shilo.silesia.pik-net.pl 981122336 23436 213.186.80.60 (2 Feb 2001 13:58:56 GMT) X-Complaints-To: news@shilo.silesia.pik-net.pl NNTP-Posting-Date: 2 Feb 2001 13:58:56 GMT X-Mailer: Mozilla 4.75 [en] (Win95; U) X-Accept-Language: en 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 P.I.KAMSOFT, Katowice tel. (+48 32) 209-07-05, fax 209-07-15 POLAND