EXP版本高于数据库导致ORA-00942

今天在执行EXP操作的时候报错，具体错误信息如下：

---

[oracle@gvora data]$ exp aaa/****@gvora

Export: Release 11.1.0.7.0 - Production on Tue Jul 28 14:23:26 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp >

(2)U(sers), or (3)T(ables): (2)U > 3

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > gvgroup

. . exporting table                    GVGROUP
EXP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >

EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully

---

经查证，ORA-00942错误信息说明如下：

---

The export views are not correctly installed. Try doing this: 
run following script.: 
1).Login in as sys user. 

2).run the $ORACLE_HOME/rdbms/admin/catexp.sql file. This will recreate all your exp related views. 

3).run the exp again. 

其实，这个错误主要是由于EXP版本高于数据库版本，导致一些方面不兼容，从而引起EXP操作出错。当换到其它机器上，使用版本同样为10.2.0.4.0的EXP程序，导出操作正常，问题解决。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15203236/viewspace-610969/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15203236/viewspace-610969/