-
help with IMP
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|