imp problem

From: Robert W. Stanford <stanford_at_cableone.net>
Date: 2000/03/14
Message-ID: <38CDF4C1.D629208B@cableone.net>#1/1

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