Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Unanswered: Oracle 8i import blues

    I get the following error when trying to do a full import of my database:


    . . 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 uer has full rights:

    GRANT connect, resource TO arsenal_build002;
    GRANT SELECT ANY TABLE TO arsenal_build002;
    GRANT UNLIMITED TABLESPACE TO arsenal_build002;

    anyone point me in the right direction?

    Thanks in advance

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    what about rights on tablespace ARSENAL_IDX ?

  3. #3
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200
    How are u doing the import.

    As which user are u doing the import try to do it as system user.and if u r doing the full database import,there is also a privilege called imp_full_db and exp_full_db,this should e given

    try it out ...

    mickykt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •