Home » RDBMS Server » Server Utilities » IMP-00023 import from 7.3.4 to 8.1.7
IMP-00023 import from 7.3.4 to 8.1.7 [message #203076] Mon, 13 November 2006 15:48 Go to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
I run the following imp command from an NT machine running Oracle 7.3.4 client:

imp73 userid=system/manager@btn.world full=y ignore=y file=F:\ORADBA\CIS\exp\cis.dmp log=F:\ORADBA\CIS\exp\cis.log

I get the following error:


Connected to: Oracle8i Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - 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

I look around and found that I needed to run catexp.sql as the SYS user on the target database, which I did successfully. The error still occurs.
This target database can be easily recreated, so if I have to blow it away, then so be it.
However, has anyone seen this behavior before?

Thanks.

[Updated on: Mon, 13 November 2006 15:48]

Report message to a moderator

Re: IMP-00023 import from 7.3.4 to 8.1.7 [message #203078 is a reply to message #203076] Mon, 13 November 2006 16:09 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should use the 8.1.7.4 import utility to import the dmp file.
Previous Topic: Stuck up in a table while Importing
Next Topic: Possible to use ...%type in external table field declaration?
Goto Forum:
  


Current Time: Wed Jun 26 13:49:39 CDT 2024