Link to home
Start Free TrialLog in
Avatar of panpanW
panpanW

asked on

import error: imp-00003 an oracle error 942 encountered.

Hi experts,

I am trying to import tables into a newly created instance.
right after I type : imp login/password

i got this error:

imp-00003 an Oracle error 942 encountered
ORA-0942 a table or view does not exist
imp-00023 imp view does not installed, please notify your DBA

What should I do to fix this problem? thanks.

SOLUTION
Avatar of seazodiac
seazodiac
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
after that, try your imp command again. the reason is that you have not created IMP/EXP dictionary views
Avatar of panpanW
panpanW

ASKER

thansk.

But, I am getting "package STANDARD not accessible" error. why?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
log in as sysdba, run catimp.sql under %ORACLE_HOME%/rdbms/admin folder
Thanks
Helped me after spending lot of tome Googling