Export: Release 188.8.131.52.0 - Production on Thu Nov 4 17:27:14 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 184.108.40.206.0 - Production
With the Partitioning option
JServer Release 220.127.116.11.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
well, can i run the 8i export from the 9i db? Our backups were earlier stored on a machine which has been upgraded to 9i from 8i as such none of the exports are running. All our dbs are 8i except the one which has been upgraded to 9i and this machine which has oracle 9i has the scheduler set to export all the the schemas from the other 8i dbs. This 9i machine has a separate drive to store the export dump files and the other 8i dbs do not have space to store the export dumps. As such I can not reschedule the exports from the 8i machines.
Is there any work around?