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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
after that, try your imp command again. the reason is that you have not created IMP/EXP dictionary views
ASKER
thansk.
But, I am getting "package STANDARD not accessible" error. why?
But, I am getting "package STANDARD not accessible" error. why?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
log in as sysdba, run catimp.sql under %ORACLE_HOME%/rdbms/admin folder
Thanks
Helped me after spending lot of tome Googling
Helped me after spending lot of tome Googling