Import log shows error while Importing Oracle9i database

[gpsk7]

Hi,

I tried importing an Oracle 9i database (which was initially exported from Oracle 9i database only), which seems to be importing all the tables perfectly fine but when I check the Import log for the database it shows me a kind of error message saying:

"IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
CREATE DIMENSION "PROMOTIONS_DIM" LEVEL..."

Can someone explain:
1. What this error message means?
2. What are its implications?
3. And what can be the appropriate fix for this?

Thanks

Regards,
gpsk

[davey23uk]

table doesnt exist - self explanatory no?

[gpsk7]

Originally posted by davey23uk
table doesnt exist - self explanatory no?

Despite showing an error, the good thing is that all tables are imported successfully and are working prefectly fine.

For more details see the given below error message:

IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:

"CREATE DIMENSION "PROMOTIONS_DIM" LEVEL "PROMO" IS ("PROMOTIONS"."PROMO_ID""
") LEVEL "SUBCATEGORY" IS ("PROMOTIONS"."PROMO_SUBCATEGORY") LEVEL "CATEGORY"
"" IS ("PROMOTIONS"."PROMO_CATEGORY") LEVEL "PROMO_TOTAL" IS ("PROMOTIONS".""
"PROMO_TOTAL") HIERARCHY "PROMO_ROLLUP" ("PROMO" CHILD OF "SUBCATEGORY" CHIL"
"D OF "CATEGORY" CHILD OF "PROMO_TOTAL") ATTRIBUTE "PROMO" DETERMINES "PROMO"
"TIONS"."PROMO_NAME" ATTRIBUTE "PROMO" DETERMINES "PROMOTIONS"."PROMO_END_DA"
"TE" ATTRIBUTE "PROMO" DETERMINES "PROMOTIONS"."PROMO_BEGIN_DATE" ATTRIBUTE "
""PROMO" DETERMINES "PROMOTIONS"."PROMO_COST" ATTRIBUTE "SUBCATEGORY" DETERM"
"INES "PROMOTIONS"."PROMO_SUBCATEGORY" ATTRIBUTE "CATEGORY" DETERMINES "PROM"
"OTIONS"."PROMO_CATEGORY" ATTRIBUTE "PROMO_TOTAL" DETERMINES "PROMOTIONS"."P"
"ROMO_TOTAL""

[gandolf989]

Originally posted by gpsk7
Despite showing an error, the good thing is that all tables are imported successfully and are working prefectly fine.

For more details see the attached Import log file.

It looks like a rights issue. Can the scema owner create a dimension and does the schema owner have direct grants for all of the tables accessed by the dimensions?