Unanswered: HELP - Export/Import with version 8.05
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 18.104.22.168.0 - Production on Mon Mar 5 11:39:55 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 22.214.171.124.0 - Production
With the Partitioning option
JServer Release 126.96.36.199.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
Export must be done using lower export utility version. In your case, it is 8.1.7. As you don't have it installed on a client, take 8.1.7 installation CD and install only utilities you need (no need to install the whole product).
Once export is done, you can import it into another 8.1.7 database (using its import utility) or into 9i using 9i's import utility.
Generally speaking, export data using export utility of the lower database version, and import it using import utility of the target database.