Re: Annoying IMP error

"Dave Campbell" <david.campbell_at_granadamedia.com> wrote in message news:d8afeb3.0307080207.1fd21189_at_posting.google.com...
> 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

Hi Dave. To create a function based index such as the two above the user must possess the system privilege QUERY REWRITE. You will need to grant this privilege to the index owner before importing those 2 indexes.

Cheers Received on Tue Jul 08 2003 - 18:47:20 CDT