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

Export :
userid=ausr/ausr
file=a.dmp
log=a.log
consistent=y
buffer=30000
compress=n

Import :
userid=busr/busr
file=a.dmp
log =ia.log
buffer=30000
commit=y
fromuser=ausr
touser=busr

Brian Peasland wrote:
>
> 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!
> ========================================
 

-- 
____________________________________________________________
Jaros³aw Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice
tel. (+48 32) 209-07-05, fax 209-07-15    POLAND