EXP Full library Data export script

Exp Userid=system/manager full=y direct=y recordlength=65535 file=/bak/exp_full.dmp log=/bak/exp_full.log

If encounter exp-00091:exporting questionable statistics.

Produce:

This error occurs when exporting (dump) database tables in a different context than the server side of the database and the client character set. Although this error occurs, it seems to have no effect on the import.

Solve:

Character Set view method for server-side data:

1, open sqlplus, with the SYS user login.

2. Execute SELECT * from v$nls_parameters WHERE parameter= ' Nls_characterset ';.

Where ' nls_characterset ' must be uppercase.

PARAMETER

--------------------

VALUE

--------------------

Nls_characterset

Zhs16gbk

Export Nls_lang=american_america. Zhs16gbk