Home » RDBMS Server » Server Utilities » IMP-00023: Import views not installed, please notify your DBA
IMP-00023: Import views not installed, please notify your DBA [message #69854] Wed, 13 March 2002 12:53 Go to next message
George
Messages: 68
Registered: April 2001
Member
Hi,

After I installed 9i on win2k and try to import a dmp to 8.1.7 database, I got this error message along with:
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

Does anybody know how to fix it?

Thanks
Re: IMP-00023: Import views not installed, please notify your DBA [message #69869 is a reply to message #69854] Thu, 14 March 2002 09:06 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Run $ORACLE_HOME/rdbms/admin/catexp.sql as SYS on the 8i database. If the problem persists it is because you are going down to an older database. Run export from the 8.1.7 code tree against the 9i database then import to 8i, i.e., exp system/manager@9idbalias.
Re: IMP-00023: Import views not installed, please notify your DBA [message #71656 is a reply to message #69869] Wed, 11 December 2002 13:05 Go to previous message
THANKS
Messages: 4
Registered: December 2002
Junior Member
Thanks!!!
Previous Topic: ORA-00972
Next Topic: Urgent !!! Import 64 bit to 32 bit oracle
Goto Forum:
  


Current Time: Mon Dec 23 17:18:59 CST 2024