Re: Annoying IMP error

First, make sure that the user that will own the index has the proper quota on the ARSENAL_IDX tablespace.

Then, make sure that the user that will is creating the index has the CREATE INDEX or CREATE ANY INDEX system privilege to be able to create this index.

HTH,
Brian

Dave Campbell wrote:
>
> Hi,
> I'm getting the following errorwhen importing my database from one
> server to another.
>
> . . importing table "WWW_POLL" 24347 rows
> imported
> IMP-00017: following statement failed with ORACLE error 1031:
> "CREATE INDEX "TTPERSPROF_EMAIL" ON "TRUSTEE_PERSONALPROFILE"
> (LOWER("EMAIL""
> ") ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 17530880
> NEXT 87244"
> "80 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST
> GROUPS 1"
> " BUFFER_POOL DEFAULT) TABLESPACE "ARSENAL_IDX" LOGGING"
> IMP-00003: ORACLE error 1031 encountered
> ORA-01031: insufficient privileges
> IMP-00017: following statement failed with ORACLE error 1031:
> "CREATE INDEX "TTPERSPROF_USERNAME" ON "TRUSTEE_PERSONALPROFILE"
> (LOWER("USE"
> "RNAME") ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL
> 11714560 NEXT"
> " 5816320 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1
> FREELIST GR"
> "OUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "ARSENAL_IDX" LOGGING"
> IMP-00003: ORACLE error 1031 encountered
> ORA-01031: insufficient privileges
> About to enable constraints...
> Import terminated successfully with warnings.
>
> The ARSENAL_IDX space was created like this:
>
> CREATE TABLESPACE ARSENAL_IDX
> DATAFILE '/global/dbdg/u03/oradata/GM_PRD/arsenal_idx01.dbf' SIZE
> 1048584K
> AUTOEXTEND ON NEXT 50M
> EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
>
> Than sk in advance
>
> Dave

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"