EXP-00091 EXP Export Error problem puzzle

Today requires partial table data to be exported

The EXP export script provided is as follows:

Userid=x/[email protected]buffer=102400rows=y Log=t_daylog_callbyservice.logfile=t_daylog_ callbyservice.dmptables=t_daylog_callbyservicequery= "where logdate between To_date (' 20150810 ', ' YYYYMMDD ') and to_ Date (' 20150828 ', ' YYYYMMDD ') "

Attempt to perform an error

$exp  parfile=t_daylog_callbyservice. Parexport: release 10.2.0.4.0 - production on tue sep 1 16:05:15  2015Copyright  (c)  1982, 2007, oracle.  all rights reserved. connected to: oracle database 10g enterprise edition release  10.2.0.4.0 - 64bit productionwith the partitioning, olap, data mining  and Real Application Testing optionsExport done in ZHS16GBK  character set and al16utf16 nchar character setabout to export  specified tables via conventional path .... . exporting table          T_DAYLOG_CALLBYSERVICE       10197 rows exportedexp-00091: exporting questionable statistics. Exp-00091: expOrting questionable statistics. Export terminated successfully with warnings.

If it prompts to error EXP-00091, check for errors

[[Email Protected]:/u01/script] $OERR exp 00091
00091, 00000, "exporting questionable statistics."
*cause:Export was able to export statistics, but the statistics
//usuable.The statistics is questionable because one or more of
The following happened during export:a row error occurred, client
//Character set or Ncharset does not match with the server, a query
//Clause was specified on export, only certain partitions or
//subpartitions were exported, or a fatal error occurred while
//processing a table.
*action:to Export non-questionable Statistics,Change the client character
//set or Ncharset to match the server, export with no query clause,
//export complete tables.If desired, import parameters can be
Supplied so then only non-questionable statistics'll be imported,
And all questionable statistics would be recalculated.

According to the above requirements may be a character set does not conform to, or when the export of the specified query sub-partition or sub-partitions are exported, or processing the table when the error occurs (limited translation capabilities, only to understand this).

To see if the client and service-side character sets match

Sql> Select Userenv (' language ') from dual; USERENV (' LANGUAGE ')----------------------------------------------------American_america.  Zhs16gbkselect * from Nls_database_parameters t where t.parameter= ' nls_characterset '; SELECT * from v$nls_parameters where parameter= ' Nls_characterset '

Adding language settings to environment variables

Export nls_lang= ' American_america. ZHS16GBK ' echo $NLS _lang

Re-export still reported 00091 error, try to remove query also error, modify the script to try to use the EXPDP tool to export the table.

Userid=x/[email Protected]directory=backupdircompression=nonecontent=alllogfile=t_daylog_ callbyservice.logdumpfile=t_daylog_callbyservice.dmptables=t_daylog_callbyservicequery= "where logdate between to_ Date (' 20150810 ', ' YYYYMMDD ') and to_date (' 20150828 ', ' YYYYMMDD ') "

The view logs are exported correctly, but it is observed that the number of rows exported is the same as the exp export of 10197 rows.

export: release 10.2.0.4.0 - 64bit production on tuesday, 01  september, 2015 15:24:24copyright  (c)  2003, 2007, Oracle.  All  rights reserved.;;;  Connected to: Oracle Database 10g Enterprise Edition Release  10.2.0.4.0 - 64bit productionwith the partitioning, olap, data mining  and Real Application Testing optionsStarting  "ICD". " Sys_export_table_01 ":   parfile=t_daylog_callbyservice. Par estimate in progress using blocks method ... processing object type table_export/table/table_datatotal estimation using  Blocks method: 168 mbprocessing object type table_export/table/tableprocessing  object type table_export/table/grant/owner_grant/object_grantprocessing object type table_export/table/index/indexprocessing object type table_export/table/index/statistics/ index_statisticsprocessing object type table_export/table/statistics/table_statistics. .  exported  "ICD". " T_daylog_callbyservice "             980.4  KB   10197 rowsMaster table  "ICD". " Sys_export_table_01 " successfully loaded/unloaded*************************************************** Dump file set for icd. sys_export_table_01 is:  /u01/temp/t_daylog_callbyservice.dmpjob  "ICD". " Sys_export_table_01 " successfully completed at 15:24:28

In other words, the export should be successful, but for some reason it is an error.

In the document EXP Utility Reports EXP-91 During Export (document ID 730106.1), the author finds an explanation of this problem.
Oracle statistics is the basis of the CBO's work. The Oracle Optimizer has evolved from Rbo to CBO in the course of its development. In the Rbo era, optimizer generation rules were solidified in code in Oracle code. The CBO's work is based on data object statistics. Statistics are reflected in the entity, which is a series of meta-data information. In the 9i era, the CBO worked with RBO, and the statistics needed to be collected and maintained manually. And, due to data changes, in some early CBO versions, "Real-time" statistics often fail to get the best execution plan. Therefore, at the beginning of the 9i Exp/imp tool, the statistic export becomes the EXP tool default behavior.

In other words, the EXP tool uses statistical functions when exporting, and the occurrence of errors is related to statistics. The problem didn't work out.

This article is from the "linuxoracle" blog, make sure to keep this source http://onlinekof2001.blog.51cto.com/3106724/1690547

EXP-00091 EXP Export Error problem puzzle