DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: help with IMP

  1. #1
    Join Date
    Jan 2008
    Posts
    45

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    UK
    Posts
    56
    Do you have a tablespace called 'LETTER_INDEX' on your target database and do you have authority to create objects in it ?

    Is this the first time that the source database has had indexes ? and hence the first time that the import has tried to create any ?

  3. #3
    Join Date
    Jan 2008
    Posts
    45

    hey

    we run this script everynight and we have no prob with it... but for some reson it failed lastnight

    here is the script:

    imp $DBUSER/$DBPASS@$DB_INSTANCE \

    file=$DUMP_DIR/$LTRDUMPFILE \

    fromuser=$SOURCE_LTR_SCHEMA touser=$LTRUSER \

    grants=N \

    LOG=$DBERR_FILE statistics=none


    then

    drop user &1 cascade;

    -- Create the user

    create user &1 identified by &1;

    -- Grant the acccess

    grant connect,resource, create session, create synonym to &1;

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Something is wrong, that's for sure.

    By the way, your previous post is confusing, it looks like you attempt to Import "then" you drop the user, recreate it and grant privs.

    Is your script spooling to a log? Look around the grant privs statement, what is says?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Jan 2008
    Posts
    45

    it is the other way

    drop user &1 cascade;

    -- Create the user

    create user &1 identified by &1;

    -- Grant the acccess

    grant connect,resource, create session, create synonym to &1;

    here is the script:

    imp $DBUSER/$DBPASS@$DB_INSTANCE \

    file=$DUMP_DIR/$LTRDUMPFILE \

    fromuser=$SOURCE_LTR_SCHEMA touser=$LTRUSER \

    grants=N \

    LOG=$DBERR_FILE statistics=none

    and also have a look at this:

    vahx0106>$ pwd

    /u51/app/hqa/librarian/db


    vahx0106>$ ls -l ltr.dmp

    -rw-r--r-- 1 hqalibjl hqa 71116800 May 16 09:17 ltr.dmp

    How do i proceed from here on............

Posting Permissions

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


Click Here to Expand Forum to Full Width