OraFAQ Forum: Server Utilities » IMP-00023: Import views not installed, please notify your DBA

Home » RDBMS Server » Server Utilities » IMP-00023: Import views not installed, please notify your DBA

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

IMP-00023: Import views not installed, please notify your DBA [message #69854]

Wed, 13 March 2002 12:53

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

Report message to a moderator

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

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.

Report message to a moderator

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

THANKS
Messages: 4
Registered: December 2002

Junior Member

Thanks!!!

Report message to a moderator

Previous Topic:	ORA-00972
Next Topic:	Urgent !!! Import 64 bit to 32 bit oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 21:47:06 CST 2025