OraFAQ Forum: Forms » IMP-00003: ORACLE error 942 encountered

Home » Developer & Programmer » Forms » IMP-00003: ORACLE error 942 encountered

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00003: ORACLE error 942 encountered [message #78741]

Wed, 13 March 2002 20:29

mandrake_ist
Messages: 3
Registered: March 2002

Junior Member

Hi,

I am trying to setup Oracle Designer 6.0.3 on my Win 98 PC. I am using Personal Oracle7 Release 7.3.3.

When I tried to build repository for Oracle Designer, I got the following error message.

I checked index and table tablespaces. Evertyhing seems OK.

Can you please help me?

Thanks in advance...

-mandrake-

MP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully

Report message to a moderator

Re: IMP-00003: ORACLE error 942 encountered [message #78748 is a reply to message #78741]

Thu, 14 March 2002 03:47

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

1.have u run catexp.sql in ur database

2.Go to hkey_local_machine/software/oracle/des2_71 or des2_70 or like that, in the registry and find out the value of execute_import and excute_export parameter and let me know

Report message to a moderator

Re: IMP-00003: ORACLE error 942 encountered [message #78758 is a reply to message #78748]

Thu, 14 March 2002 09:41

mandrake_ist
Messages: 3
Registered: March 2002

Junior Member

hi again,

i run catexp.sql.. parameters are following.

thanks.

-mandrake-

EXECUTE_EXPORT c:orawin95binexp80.exe

EXECUTE_GUI_EXPORT c:orawin95binexp80.exe

EXECUTE_GUI_IMPORT c:orawin95binimp80.exe

EXECUTE_IMPORT c:orawin95binimp80.exe

Report message to a moderator

Re: IMP-00003: ORACLE error 942 encountered [message #78762 is a reply to message #78748]

Thu, 14 March 2002 22:31

mandrake_ist
Messages: 3
Registered: March 2002

Junior Member

hi guys,

I explored the problem and would like to share it.
Designer 6.0 looks for Personal Oracle 7.3.4 at least.
im using an older one than that
Oracle 7.3.3..
by the way, how can i find oracle 7.3.4?
almost impossible, right?

-mandrake_ist-

Report message to a moderator

Previous Topic:	Datmodeling
Next Topic:	Passing value Throught form to report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:47:53 CDT 2024