EXP 导出时遇到错误 EXP-00091: Exporting questionable statistics.

                            解决导出成功但报错EXP-00091: Exporting questionable statistics.


今天使用exp导出遇到错误EXP-00091: Exporting questionable statistics.

[oracle@test1 bin]$ exp scott/tiger  file='/oradata/export.dmp' tables=test log='/oradata/export.log'

Export: Release 11.2.0.4.0 - Production on Mon Feb 22 14:22:06 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                           TEST
. . exporting partition                             P1          1 rows exported
. . exporting partition                             P2          7 rows exported
. . exporting partition                             P3          6 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

查看了一下导出的文件,没问题。报错其实可以忽略,但是哪里报错呢

查一下好像是字符集的事情

sqlplus / as sysdba

SQL> select userenv('language') from dual;


USERENV('LANGUAGE')
----------------------------------------------------



修改字符集下面填你上面查到的字符集
[oracle@test1 bin]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

[oracle@test1 bin]$ exp scott/tiger  file='/oradata/export.dmp' tables=test log='/oradata/export.log'

Export: Release 11.2.0.4.0 - Production on Mon Feb 22 14:26:17 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                           TEST
. . exporting partition                             P1          1 rows exported
. . exporting partition                             P2          7 rows exported
. . exporting partition                             P3          6 rows exported
Export terminated successfully without warnings.


在导出有条件的记录时还是会出错,可能跟转义字符“ 、‘、( 、> 这些有关系吧

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、付费专栏及课程。

余额充值