Annoying IMP error

From: Dave Campbell <david.campbell_at_granadamedia.com>
Date: 8 Jul 2003 03:07:01 -0700
Message-ID: <d8afeb3.0307080207.1fd21189@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 Received on Tue Jul 08 2003 - 05:07:01 CDT