Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The solution of EXP-00091 error when using EXP for backup

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

1. An EXP-00091 error is reported when using the EXP tool to export backup or migrate data

[oracle@auto tmp] $exp luffy/onepiece full=Y constraints=Y file=/home/oracle/tmp/luffy.dmp

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . Exporting table MGMT_POLICY_ASSOC_CFG 364 rows exported

two。 Treatment method

Specify the NLS_LANG environment variable of the Linux system as the dataset of the database

SQL > select userenv ('language') from dual

USERENV ('LANGUAGE')

AMERICAN_AMERICA.AL32UTF8

SQL >

Set the NLS_LANG environment variable for Linux operating system

[oracle@auto tmp] $export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

The method to modify the environment variables of the Window system is:

C:\ > set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

3.OK, after processing, this error will not be reported during the EXP export operation.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report