Home » RDBMS Server » Backup & Recovery » HELP - Export/Import with version 8.05
HELP - Export/Import with version 8.05 [message #222475] Mon, 05 March 2007 00:49 Go to next message
Messages: 1
Registered: February 2007
Junior Member
I'm running Oracle 8.05 with Windows 2003 Server
From Client i'm running 0racle 9i with Windows XP Profeshional
from command promt of client, i want export database server, but i has som error:
C:\>exp sys/sys@newtnama file=D:\Backup\test.dmp owne
r = test

Export: Release - Production on Mon Mar 5 11:39:55 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release - Production
With the Partitioning option
JServer Release - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

please help me
Re: HELP - Export/Import with version 8.05 [message #222477 is a reply to message #222475] Mon, 05 March 2007 01:18 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

The version of the Export utility must be equal to the earliest version of the source or target database.

Re: HELP - Export/Import with version 8.05 [message #222529 is a reply to message #222475] Mon, 05 March 2007 05:25 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
in other words,
Use the lower version to export (from a higher version) and use lower version to import (into higher version).
You may need to install the related views in the target database.
Previous Topic: RMAN catalog
Next Topic: Suggestion on Backup
Goto Forum:

Current Time: Fri Jul 28 08:27:19 CDT 2017

Total time taken to generate the page: 0.20709 seconds