IMP-00017, ORA-00942, IMP-00041 while import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: IMP-00017, ORA-00942, IMP-00041 while import

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Unhappy

    Hi,

    I got foll. errors while importing using fromuser, touser in import.

    IMP-00017: following statement failed with ORACLE error 942:
    "GRANT SELECT ON "APPLSYS"."FND_ORACLE_USERID_S" TO "ODEVIEW""
    IMP-00003: ORACLE error 942 encountered
    ORA-00942: table or view does not exist

    IMP-00041: Warning: object created with compilation warnings
    "CREATE FORCE VIEW "APPS"."BOM_RESOURCES_ALL_V" ("
    ""RESOURCE_ID","RESOURCE_CODE","DESCRIPTION","UNIT_OF_MEASURE","COST_ELEMENT"
    "_ID","DISABLE_DATE","ORGANIZATION_ID","COST_CODE_TYPE","LAST_UPDATE_DATE",""
    "LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","PURCHASE"
    "_ITEM_ID","FUNCTIONAL_CURRENCY_FLAG","DEFAULT_ACTIVITY_ID","RESOURCE_TYPE","
    ""AUTOCHARGE_TYPE","STANDARD_RATE_FLAG","DEFAULT_BASIS_TYPE","ABSORPTION_ACC"
    "OUNT","ALLOW_COSTS_FLAG","RATE_VARIANCE_ACCOUNT","EXPENDITURE_TYPE","ATTRIB"
    "UTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUT"
    "E5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTR"
    "IBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","REQUEST_I"
    "D","PROGRAM_APPLICATION_ID","PROGRAM_ID","PROGRAM_UPDATE_DATE") AS "
    "SELECT BR.RESOURCE_ID, BR.RESOURCE_CODE, BR.DESCRIPTION, BR.UNIT_OF_MEASURE"
    ", BR.COST_ELEMENT_ID, BR.DISABLE_DATE, BR.ORGANIZATION_ID, BR.COST_CODE_TYP"
    "E, BR.LAST_UPDATE_DATE, BR.LAST_UPDATED_BY, BR.CREATION_DATE, BR.CREATED_BY"
    ", BR.LAST_UPDATE_LOGIN, BR.PURCHASE_ITEM_ID, BR.FUNCTIONAL_CURRENCY_FLAG, B"
    "R.DEFAULT_ACTIVITY_ID, BR.RESOURCE_TYPE, BR.AUTOCHARGE_TYPE, BR.STANDARD_RA"
    "TE_FLAG, BR.DEFAULT_BASIS_TYPE, BR.ABSORPTION_ACCOUNT, BR.ALLOW_COSTS_FLAG,"
    " BR.RATE_VARIANCE_ACCOUNT, BR.EXPENDITURE_TYPE, BR.ATTRIBUTE_CATEGORY, BR.A"
    "TTRIBUTE1, BR.ATTRIBUTE2, BR.ATTRIBUTE3, BR.ATTRIBUTE4, BR.ATTRIBUTE5, BR.A"
    "TTRIBUTE6, BR.ATTRIBUTE7, BR.ATTRIBUTE8, BR.ATTRIBUTE9, BR.ATTRIBUTE10, BR."
    "ATTRIBUTE11, BR.ATTRIBUTE12, BR.ATTRIBUTE13, BR.ATTRIBUTE14, BR.ATTRIBUTE15"
    ", BR.REQUEST_ID, BR.PROGRAM_APPLICATION_ID, BR.PROGRAM_ID, BR.PROGRAM_UPDAT"
    "E_DATE FROM BOM_RESOURCES BR"

    I used foll. imp command.

    imp system/manager@dev file=xyz.dmp fromuser=apps touser=apps full=N ignore=Y constraints=Y buffer=1000000 log=xyz.log

    I checked that APPLSYS.FND_ORACLE_USERID_S and BOM_RESOURCES BR are existing in database.

    any idea?

    Thanks in Adv.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    You may want to do the import with GRANTS=N and then do the grants later. Doe user ODEVIEW exist before the import?

    I sometimes do grants separately just to keep down the number of errors.

  3. #3
    Join Date
    Sep 2001
    Posts
    200
    is the fromuser same as the touser? If not check write priveleges on the concerned table and compare to those that succeeded.
    Life is what is happening today while you were planning tomorrow.

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