【转】EXP-00091: Exporting questionable statistics.解决方法

今日EXP数据发现:

EXP-00091: Exporting questionable statistics.
. . exporting table                     MV_SERVICE       1022 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                  MV_SERVICEFEE        691 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                     PLAN_TABLE          0 rows exported
. . exporting table             TAB_BROWSERCATALOG    1407427 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                 TAB_BROWSERFEE      59233 rows exported……………………………

解决方法:

select * from nls_database_parameters t where t.parameter=’NLS_CHARACTERSET’

or
select * from v$nls_parameters  where parameter=’NLS_CHARACTERSET’;
查询值为:ZHS16CGB231280

然后vi /home/oracle/.bash_profile

export NLS_LANG=american_america.ZHS16CGB231280

source /home/oracle/.bash_profile

 

原文地址:http://my.donews.com/dalezhu/2007/06/06/post-070606-112605-611/

2025-03-10T06:43:37.165038Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-03-10T06:43:37.165092Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2025-03-10T06:43:37.165104Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.18) starting as process 26836 ... 2025-03-10T06:43:37.169695Z 0 [Note] InnoDB: PUNCH HOLE support not available 2025-03-10T06:43:37.169704Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2025-03-10T06:43:37.169706Z 0 [Note] InnoDB: Uses event mutexes 2025-03-10T06:43:37.169708Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2025-03-10T06:43:37.169709Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2025-03-10T06:43:37.169711Z 0 [Note] InnoDB: Using Linux native AIO 2025-03-10T06:43:37.169831Z 0 [Note] InnoDB: Number of pools: 1 2025-03-10T06:43:37.169878Z 0 [Note] InnoDB: Using CPU crc32 instructions 2025-03-10T06:43:37.170938Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2025-03-10T06:43:37.178293Z 0 [Note] InnoDB: Completed initialization of buffer pool 2025-03-10T06:43:37.179917Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2025-03-10T06:43:37.191665Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2025-03-10T06:43:37.195822Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2025-03-10T06:43:37.195863Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2025-03-10T06:43:37.209862Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2025-03-10T06:43:37.210297Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2025-03-10T06:43:37.210301Z 0 [Note] InnoDB: 32 n
最新发布
03-11
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值