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

Thread: Import log shows error while Importing Oracle9i database

Threaded View

  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 09:04 PM.

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