Home » RDBMS Server » Server Utilities » exporting oracle 8i data from oracle 9i
exporting oracle 8i data from oracle 9i [message #8937] Sun, 05 October 2003 05:36 Go to next message
Rehman
Messages: 19
Registered: February 2000
Junior Member
Iam trying to exproting from oracle 8i data from
oracle 9i but it shows me an error message.os is
redhat linux 9

EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

Report message to a moderator

Re: exporting oracle 8i data from oracle 9i [message #8949 is a reply to message #8937] Mon, 06 October 2003 06:31 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
always use the lower version of exp to export 
and 
lower version of imp to do the import
else...
you have to install the higher versions (9i) views related to export/ import , into the lower version (8i)

Report message to a moderator

Previous Topic: Problems with TNS
Next Topic: about 9i migration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 22:18:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.