Re: Import bug in 8i ...(?)

Jarek,

Could you provide the exact syntax (specifically the parameters) of your import?

Thanks,
Brian

Jarek Palka wrote:
>
> 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
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================