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
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 - Production
JServer Release - 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?


[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
Messages: 2794
Registered: April 2006
Senior Member
You should use the import utility to import the dmp file.
Previous Topic: Interpreting SQL Loader Load File
Next Topic: To avoid duplicate rows in oracle 8i
Goto Forum:

Current Time: Tue Aug 22 04:01:56 CDT 2017

Total time taken to generate the page: 0.01531 seconds