Re: HELP! (novice) question on "imp"ort
Date: 23 Jun 93 02:09:36 GMT
Message-ID: <Jun.22.22.09.33.1993.11711_at_andromeda.rutgers.edu>
grins_at_mariner.corp.sgi.com (Randall Grinstead) writes:
>I've used Oracle a few times (but am definitely not a DBA :-) and
>have not come across the following error. I greatly appreciate
>it if someone could please let me know what might be causing the
>problem. (It would be nice if Oracle would at least tell you
>*what* table or view does not exist!)
>Thanks in advance!
> - Randy
>-------------------------------------------------------------------
>oracle_at_les_paul [179]: imp test/test
>Import: Version 6.0.33.3.1 - Production on Tue Jun 22 18:20:07 1993
>Copyright (c) Oracle Corporation 1979, 1989. All rights reserved.
>Connected to: ORACLE RDBMS V6.0.33.3.1 - Production
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>System error message: No such file or directory
>IMP-00023: Import views not installed, please notify your DBA
>IMP-00000: Import terminated with error
>oracle_at_les_paul [180]:
Have you recently upgraded your SQL*Tools such as import ?
This happened to me on a PC version of Oracle when I upgraded
the import program that comes with RDBMS 5.1C to the one that
comes with v6.0.
Try re-installing the import tool. That's what worked for me.
Rich H.
Rutgers U.
Received on Wed Jun 23 1993 - 04:09:36 CEST