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

[samdba]

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.

[gandolf989]

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.

[ndisang]

is the fromuser same as the touser? If not check write priveleges on the concerned table and compare to those that succeeded.