1824297 Members
4843 Online
109669 Solutions
New Discussion

Oracle import error 942

 
Leo Cusson
Occasional Contributor

Oracle import error 942

I know this is not and HP problem. I amd install oracle for the 1st time. Has
someone seen this error before. I must have missed something on the install
but I can't figure it out. I am trying to import a database and I am getting
the following error;

[oracle] imp
Import: Release 8.0.5.0.0 - Production on Tue Feb 23 16:16:39 1999
(c) Copyright 1998 Oracle Corporation. All rights reserved.

Username: pk1
Password:

Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production

IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully

Any suggestions????
1 REPLY 1
Gulam Mohiuddin_1
Occasional Contributor

Re: Oracle import error 942

Please install Data Dictionary views for export. Execute the script catexp.sql
from Svrmgr while connecting as Sys or Internal account. You can find this
scripts in Oracle Home.

Oracle needs those dictionary tables to store status of all export and imports.

Thanks

Gulam.