Import log shows error while Importing Oracle9i database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import log shows error while Importing Oracle9i database

  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Import log shows error while Importing Oracle9i database

    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
    Last edited by gpsk7; 03-15-2005 at 08:04 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    table doesnt exist - self explanatory no?

  3. #3
    Join Date
    Mar 2005
    Posts
    2
    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""
    Last edited by gpsk7; 03-16-2005 at 09:02 PM.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    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?
    this space intentionally left blank

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