Why do we get the following error? This import takes place every day and we have not changed it.



We use the imp command.





Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options



Export file created by EXPORT:V10.02.01 via conventional path



Warning: the objects were exported by LTR, not by you



import done in US7ASCII character set and AL16UTF16 NCHAR character set

. importing LTR's objects into LTRPROD

. . importing table "COMPONENT" 4907 rows imported

. . importing table "COMPONENT_DIFF" 0 rows imported

. . importing table "COMPONENT_PART" 22374 rows imported

. . importing table "COMPONENT_PART_DIFF" 0 rows imported

. . importing table "COMPONENT_RULE" 359 rows imported

. . importing table "COMPONENT_RULE_DIFF" 0 rows imported

. . importing table "TEXT_VALUE_DIFF" 0 rows imported

. . importing table "USER_SIGNATURE" 187 rows imported

IMP-00017: following statement failed with ORACLE error 1031:

"CREATE UNIQUE INDEX "USER_SIGNATURE_PK" ON "USER_SIGNATURE" ("USER_ID" ) P"

"CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 10485760 FREELISTS 1 FREE"

"LIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "LETTER_INDEX" NOLOGGING"

IMP-00003: ORACLE error 1031 encountered

ORA-01031: insufficient privileges

. . importing table "WORD_DOCUMENT" 307 rows imported

. . importing table "WORD_TABLE" 110 rows imported

. . importing table "WORD_TABLE_HEADING" 472 rows imported

About to enable constraints...

Import terminated successfully with warnings.