EXP Error

[vr76413]

Hello all..

I was trying to EXP 817 DB using 901 EXP utility, since my Target DB will be 901.

Its working Fine when i use 817 EXP utility. But when i use 901 EXP tool, this is what i get.

***********************************************************
C:\Or901Home\BIN>exp system/password@lyris buffer=10000 file=c:\backup\lyris\lyris901.dmp log=c:\backup\lyris\lyris.log full=y consistent=y

Export: Release 9.0.1.1.1 - Production on Fri Jul 18 09:06:15 2003

(c) Copyright 2001 Oracle Corporation. All rights reserved.


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

*****************************************************

Any one has any idea why this is happening ?. Any help is appreciated

Thanks
Ron

[ggnanaraj]

Use 817 exp utility to export from 817 database. So also, use 9i imp utility to import the 817 exp dump file into the 9i database.

HTH.

[shashikumar]

To perform EXPORT backup using 9i exp utility for an 8i database it is not possible.

1. Use the export utility of Oracle 8.1.7 or still lower version exp utility and import using 9i import utility.
2. If your upgrading to 9i, go for oracle 9i rel 2
i.e, 9.2.0.3 which is recent version. Since 9.0.1.0 is a bug product.

You cannot perform EXPORT Backup using higher version EXP utility to a database of Lower version.