ORA-904 "MAXSIZE" When Exporting From 10g Database Using 11g Export Client.(exp)

if you use 11g client to export 10g schema, you willget this error.

check metalink document ID 957380.1

Cause

When export any objects export client run a query agains dictionary view SYS.EXU9STOU to gather storage parameters about object segments.

Since release 11g this view has been updated by a new column MAXSIZE. When using the release 11g export client the utility expect the MAXSIZE column SYS.EXU9STOU of source database.

Given the fact that this column is unavailable in 10g the ORA-904 is reported.

solution: user data pump

error:
exp test/test@orcl file=test.dmp log=test.log
getting errors
EXP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier

reference: http://halimju.wordpress.com/2010/07/08/exp-00008-oracle-error-904-encountered-ora-00904-maxsize-invalid-identifier-ora-01003-no-statement-parsed/