Re: imp problem

Hi

You really shouldn't create ANY table owned by SYS. If they really are owned by SYS import them to an other user (by fromuser=SYS touser=SCOTT).
Also you shouldn't create any tables or indexes to SYSTEM tablespace. (alter user SCOTT default tablespace DATA (or something else))

rgrds.
Kari Pannila
Oracle DBA (OCP)

PS. Delete X from my mail address , it (X) is only for SPAMMERS.

"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?

--