Re: imp problem

From: Em Pradhan <empradhan_at_dplus.net>
Date: 2000/03/14
Message-ID: <38CEC113.C621F12B@dplus.net>#1/1

Just use ignore=y option while importing HTH
pradhan

"Robert W. Stanford" wrote:

> Export file created by EXPORT:V08.01.05 via conventional path
> import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR
> character set
> . importing SYSTEM's objects into SYSTEM
> . importing SYS's objects into SYS
> . . importing table "BANNER" 6 rows
> imported
> IMP-00017: following statement failed with ORACLE error 2001:
> "ALTER TABLE "BANNER" ADD CONSTRAINT "BANNER_PK" PRIMARY KEY
> ("BANNER_ID") "
> "USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 106496
> NEXT "
> "106496 MINEXTENTS 1 MAXEXTENTS 300 PCTINCREASE 1 FREELISTS 1 FREELIST
> GROUP"
> "S 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" ENABLE NOVALIDATE"
>
> I get this error....should I import into a table owned by system or
> something?
>
> all the tables that I am importing are owned by sys? what is the deal?
> do I need to grant special rights or something?
Received on Tue Mar 14 2000 - 00:00:00 CST