Re: HELP! (novice) question on "imp"ort

In article <Jun.22.22.09.33.1993.11711_at_andromeda.rutgers.edu>, holowcza_at_andromeda.rutgers.edu (Richard D Holowczak) writes:
> 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.

Have you run expvew.sql and/or catalog.sql after your install?

Harold McCabe
mccabe_at_gdls.com Received on Thu Jul 01 1993 - 18:20:46 CEST