Shulou(Shulou.com)06/01 Report--

First, explain the version of the database.

Server: 10.2.0.5.0

Client: 11.2.0.1.0

An error will be reported when exporting.

EXP-00008: encountered ORACLE error 1003

ORA-01003: no statement parsed

And

EXP-00008: encountered ORACLE error 904

ORA-00904: "MAXSIZE": invalid identifier

This sample problem, how can not think of the client can not be compatible with it, trapped me for a long time. I decided to try to see if there was a client incompatibility problem, and sure enough, it was.

A virtual machine is installed and the client version is 10.2.0.4.0

Exp will be carried out immediately, but the report is still wrong.

EXP-00091: Exporting questionable statistics.

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

Select * from nls_database_parameters t where t.parameterized parts of NLSs

Or

Select * from v$nls_parameters where parameter='NLS_CHARACTERSET'

The result is: ZHS16GBK

Then set the character set:

Window platform: WINNT > set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

After setting, check whether the value of NLS_LANG is consistent in the environment variable, and if it is inconsistent, you can modify it in the environment variable.

LINUX > export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.