Monday, September 28, 2009

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.
---------------------------------------------

-------TO ABOID following message when export data.



cmd> set  NLS_LANG=.WE8MSWIN1252 SQL>

example:



C:\Users\Halimm>sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:03 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> $exp icms_stage\icms_stage file=C:\halim_documents\icms2_dump\icms_stage_14022014.dmp owner=icm

Export: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:15 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ICMS_STAGE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ICMS_STAGE
About to export ICMS_STAGE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ICMS_STAGE's tables via Conventional Path ...
. . exporting table                        ADDRESS       2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table          AVAILABILITY_CALENDAR       2213 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table           BACKUP_SECURITY_USER       2372 rows exported
. . exporting table                        COMPANY       2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                        CONTACT       2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                    COUNTY_TYPE        161 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                  DIVISION_TYPE         14 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table           FUNCTIONAL_ROLE_TYPE         43 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table           FUNCTIONAL_USER_ROLE        451 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                   HOLIDAY_TYPE         64 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                 LEAVE_CALENDAR        231 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                        MIG_LOG         26 rows exported
. . exporting table   MIG_ROLE_TYPE_IS_JUDGE_SECRE         78 rows exported
. . exporting table MIG_SECURITY_ROLE_TYPE_DETAILS         92 rows exported
. . exporting table           OFFICE_LOCATION_TYPE         10 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                  POSITION_TYPE         33 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                SECURITY_DETAIL       1900 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table              SECURITY_QUESTION          3 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table             SECURITY_ROLE_TYPE         39 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                  SECURITY_USER       2385 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                  SITE_CALENDAR       6831 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                    SITE_COUNTY        527 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                      SITE_SLOT      40105 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                      SITE_TYPE         98 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                      SLOT_TYPE          8 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                     STATE_TYPE         50 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                    USER_COUNTY       1058 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                USER_CREDENTIAL       2242 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                     USER_GROUP        111 rows exported
. . exporting table               USER_STATUS_TYPE          6 rows exported
EXP-00091: Exporting questionable statistics.
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.

SQL>
SQL>
SQL>
SQL>
SQL> exit

C:\Users\Halimm>set NLS_LANG=.WE8MSWIN1252
C:\Users\Halimm>
C:\Users\Halimm>sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:03 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> $exp icms_stage\icms_stage file=C:\halim_documents\icms2_dump\icms_stage_14022014.dmp owner=icm

Export: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:15 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

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

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ICMS_STAGE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ICMS_STAGE
About to export ICMS_STAGE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ICMS_STAGE's tables via Conventional Path ...
. . exporting table                        ADDRESS       2384 rows exported
. . exporting table          AVAILABILITY_CALENDAR       2213 rows exported
. . exporting table           BACKUP_SECURITY_USER       2372 rows exported
. . exporting table                        COMPANY       2384 rows exported
. . exporting table                        CONTACT       2384 rows exported
. . exporting table                    COUNTY_TYPE        161 rows exported
. . exporting table                  DIVISION_TYPE         14 rows exported
. . exporting table           FUNCTIONAL_ROLE_TYPE         43 rows exported
. . exporting table           FUNCTIONAL_USER_ROLE        451 rows exported
. . exporting table                   HOLIDAY_TYPE         64 rows exported
. . exporting table                 LEAVE_CALENDAR        231 rows exported
. . exporting table                        MIG_LOG         26 rows exported
. . exporting table   MIG_ROLE_TYPE_IS_JUDGE_SECRE         78 rows exported
. . exporting table MIG_SECURITY_ROLE_TYPE_DETAILS         92 rows exported
. . exporting table           OFFICE_LOCATION_TYPE         10 rows exported
. . exporting table                  POSITION_TYPE         33 rows exported
. . exporting table                SECURITY_DETAIL       1900 rows exported
. . exporting table              SECURITY_QUESTION          3 rows exported
. . exporting table             SECURITY_ROLE_TYPE         39 rows exported
. . exporting table                  SECURITY_USER       2385 rows exported
. . exporting table                  SITE_CALENDAR       6831 rows exported
. . exporting table                    SITE_COUNTY        527 rows exported
. . exporting table                      SITE_SLOT      40105 rows exported
. . exporting table                      SITE_TYPE         98 rows exported
. . exporting table                      SLOT_TYPE          8 rows exported
. . exporting table                     STATE_TYPE         50 rows exported
. . exporting table                    USER_COUNTY       1058 rows exported
. . exporting table                USER_CREDENTIAL       2242 rows exported
. . exporting table                     USER_GROUP        111 rows exported
. . exporting table               USER_STATUS_TYPE          6 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

SQL>


No comments: