Several error exp-00008,ora-00904,ora-01003,exp-00091 about Oracle's export data

First describe the version of the database

Server: 10.2.0.5.0

Client: 11.2.0.1.0

Export will error

EXP-00008: Encountering ORACLE error 1003

Ora-01003:no statement parsed

And

EXP-00008: Encountering ORACLE error 904

ORA-00904: "MAXSIZE": Invalid identifier

This sample problem, how also can not think of is the client can not backward-compatible bar, trapped me for a long time. I decided to try out whether the client is incompatible with the problem, and sure enough.

A virtual machine is installed and the client version is 10.2.0.4.0

Exp immediately, or an error.

Exp-00091:exporting questionable statistics.

Wipe, this error Baidu a check, since it is a character set problem, immediately query the next server on the character set is what?

SELECT * from Nls_database_parameters t where t.parameter= ' nls_characterset ';

Or

SELECT * from v$nls_parameters where parameter= ' nls_characterset ';

The result is: ZHS16GBK

Then set the CharSet:

window Platform:winnt> set Nls_lang=american_america. ZHS16GBK

After setting, see if the value of Nls_lang is consistent in the environment variable, and if the inconsistency can be modified in the environment variable.
Linux> export Nls_lang=american_america. Zhs16gbk

This article from "Puma Bar" blog, reproduced please contact the author!